Date Time Convertion

  • Thread starter Thread starter Rudi Groenewald
  • Start date Start date
R

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
 
Thanks alot, problem solved :)
Chris said:
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


.
Click to expand...
Click to expand...
 
Back
Top