format for datetime to pass to (datetime) parameter

[hc5316]

Hi,

I'm using asp page connect to crystal server to get report.

For Datetime parameter... I use the same format as console:
DateTime(2003,3,31,0,0,0)

However, it seems the value of parameter (that the report received) is not correct... The report display the parameter value as:
12/30/1899 12:00:00AM

What is the correct format ?

Thanks,
-Howard

 

[Turkbear]

Hi,
It depends on the database but do not confuse what you see
with the actual format needed to retrieve data using the field in the where clause...

In Oracle, for instance, what you are seeing is the one form of the output format for the DateTime you entered..

 

[synapsevampire]

How are you passing the parameter, that's the key here.

Please post the code, not the result of something that didn't work...

-k