Coversion date format

[trustsun]

I need to convert the format mm/dd/yyyy hh/mm/ss to just mm/dd/yyyy format and query by paremeter using the format mm/dd/yyyy. But I get the type mismatch error.

A little help and example please.

 

[PHV]

Have you defined the parameter as DateTime ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[trustsun]

Using this; GroupDate: Format(DateAdd("d",IIf(([startdatetime]-Int([startdatetime]))<0.25,-1,0),[startdatetime]),"mm/dd/yy dddd")
The field "startdatetime" is mm/dd/yyy hh/mm/yyy, now I need to convert like mm/dd/yyyy only. Possible in another field?

 

[PHV]

Does this raise an error too?
GroupDate: Format([startdatetime],"mm/dd/yy dddd")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[PaulBricker]

Why can't you just use
CDate(Format([startdatetime],"mm/dd/yy"))

That should return the value as a date/time so that your parameters work.


Paul