entering datetime parameter as yyyy-mm-dd 00:00:00

[americvish]

Hi,
I have 2 parameters in the crystal report 2008.start_date and end_date which are like datetime format. when the user enters the value for the above parameters, he should be able to enter as "yyyy-mm-dd 00:00:00" when selected from the calender(keeping the time format as default to 00:00:00) and pass the same value to the query with the datetime format.
is there any turn around process for making datetime format default to "yyyy-mm-dd 00:00:00"?

 

[Madawc]

Soemthing odd about this posting: it showed as 'new' but is from last month.

To answer the question, you ought to be able to adjust a parameter to be Date rather than Datetime. Or have separate date and time parameters, if you need them.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP