Date Parameter/Filter in list report

[cbyrne]

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

[cbyrne]

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