DateTime to Date in a parameter

[ClowneUser]

Hi,

I'm using Crystal XI querying a Oracle 10g database, a field that i would like to use as a date parameter is datatime, is there any way to convert this so its date?

Thanks in advance.

Mick.

 

[lbass]

You should be able to use a date parameter with a datetime field without any conversion. Or are you saying you want to create a dropdown list (instead of using the calendar) that shows dates instead of datetimes?

-LB

 

[Ox73]

If all you are looking for is to convert your DATE/TIME to DATE in order to make it a parameter you can do it as follows:
In FORMULA FIELDS create a date formula date(DateTimeField) Then you can create your parameter out of this new field and it will only promt you for the date and not the date/time

 

[ClowneUser]

Thanks guys for your help, all sorted now.

Much appreciated.
Mick.