Date Time Convertion

[Rudi Groenewald]

Hi there...

I need to get a valaue from my form to SQL server, and for some reason the
server only allows the format MM/DD/YYYY HH:MM ....

When my users selects the date off a activeX calendar, it inserts it into a
form field, but in the format DD/MM/YYYY...

I need to get that converted to the format the server accepts, I tried this
functions in another field: =FormatDateTime([date1],[MM/DD/YYYY])

but that doesn't work... what am I doing wrong? and what can I do to correct
this error?

thanks
Rudi

 

[Chris]

Try ...

 

[Rudi Groenewald]

Thanks alot, problem solved

Try ...

-----Original Message-----
Hi there...

I need to get a valaue from my form to SQL server, and for some reason the
server only allows the format MM/DD/YYYY HH:MM ....

When my users selects the date off a activeX calendar, it inserts it into a
form field, but in the format DD/MM/YYYY...

I need to get that converted to the format the server accepts, I tried this
functions in another field: =FormatDateTime([date1], [MM/DD/YYYY])

but that doesn't work... what am I doing wrong? and what can I do to correct
this error?

thanks
Rudi


.