Hello All - Has anyone come accross date paramters and the report freezing when trying to run. I have custom field dates in other reports but when i try and use the user defined date field it doesn't work. Below is my data item plus my parameter filter.
Filter:
[OBJ_UDFDATE01] BETWEEN TO_DATE(?SEL_DATE?, 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE(?SEL_ENDDATE?, 'YYYY-MM-DD HH24:MI:SS')
Data Item
TO_DATE([Work].[R5OBJECTS].[OBJ_UDFDATE01],'MM-DD-YYYY HH24:MI:SS')
Any help would be greatly appreciated.
Thank You
Chris
Its okay i finally did it, :)
I have previously been using custom field dates in my reports and never used UDFDATES and realised that it was much simpler as i just needed to create a prompt page with the SEL_DATE > SEL_ENDDATE instead of creating a filter with these.
Thanks Anyway for looking.
Chris