Date Prompts

[tunjio]

I have a date condition in a universe as follows:

PS_JOB.ACTION_DT >= to_date(@Variable('Enter the first date of the date range')) AND PS_JOB.ACTION_DT <= to_date(@Variable('Enter the last date of the date range'))))

The database is oracle 8.1 and the Action Date column is a date type column with dates in the format Dd/Mm/Yyyy. The prompt allows values to be entered only in the format Dd-Mm-Yyyy and not Mm/Dd/Yyyy which is the preferred format of the end users.

Can anyonehelp by telling me how i can force this prompt to recognise the Mm/Dd/Yyy format?

 

[tommyboyau]

try something like
to_date(@Variable('Enter the first date of the date range') , 'MM/dd/YYYY')
Where the second part of to_date is where you specify the format.

Thanks,

Tom