Change the format of the date

[maas]

Hello Everybody,

I am having a report which has two separate commands which I have created them by adding a SQL command. In the SQL command, I am defining a condition where the cflows.date <= to_char('20090131','yyyymmdd').
Now, the problem is that I want to add a parameter to the command in crystal and replace the to_char('20090131','yyyymmdd')with a date which will be prompted by the user {?end_date}, but it is not accepting because the format is different. If I change the format of the parameter to number, it will accept. But, if the type is date, it will show an error.

So, how can I deal with this issue.

Thanks

 

[lbass]

Try:

to_date(cflows.date) <= {?date}

...using a date parameter.

-LB

 

[maas]

Hello lbass,

It did not work .... an error is showing that it can not be converted to type of date

 

[lbass]

Is it already a date? What happens if you just use:

cflows.date <= {?date}

-LB