converting to UK dates

[gojohnnygogogogo]

hello,
I have a problem with Dates, I am passing UK date like 01/05/2002 to a crystal report and it keeps converting it to 05/01/2002.
has anybody seen this problem before ?

(ps, I am passing from asp and it says to use :
' Here is the list of parameter field types and their number,
' and the VBScript calls to convert the variable from a Variant
' to the right data type:
'
' Param Field Type VBScript Call Type Number
'
' NumberField CDbl 7
' CurrencyField CDbl 8
' Boolean CBool 9
' DateField CDate 10
' StringField CStr 12

 

[dgillz]

This is a format issue, just format the objects in question and you will see the UK format as an available option. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[lyanch]

Is the report changing the format? or actually sending the wrong parameter value to the DB?

Lisa

 

[gojohnnygogogogo]

I have formated the field ,so it is UK, and I am still getting this problem.

I think it is sending the wrong parameter, ( IF I type 1/september/1991 it sends the right paramter, if I type 1/9/1991 it sends the wrond parameter.

 

[dgillz]

If this is a date parameter, why are you typing anything? Just pick the date from the drop down calendar. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[gojohnnygogogogo]

It works fine from the cRystal designer.
I am passing parameters from an ASP page.