date to fix this

Results 1 to 3 of 3

Thread: date to fix this

  1. #1
    Join Date
    Dec 1969

    Default date to fix this

    Hi all,<BR><BR>I have a field which I keep to the user entry...I am using MS Access.<BR><BR>I am having a problem on our server date/time field.<BR><BR>In my local system there is no problem ..<BR><BR>but online....there was a problem...I mean the dates used to appear with 4.28.2003.<BR><BR>System there was not accepting the dates so I used<BR>TimeofVisit = now<BR>replace(TimeofVisit,".","/")<BR><BR>Now we are getting strange results like the below.<BR>4/3/2028 2:38:58 PM<BR><BR>I was supposed to be 4th April 2003....<BR><BR>Is there any solutions that I can have the now function used in access field for getting the date & time values.<BR><BR>Thanks for your input & time<BR><BR>Jay

  2. #2
    Join Date
    Dec 1969

    Default FormatDatetime() <eop>


  3. #3
    Join Date
    Dec 1969

    Default Set the LCID properly...

    ...and *THEN* use FormatDateTime!<BR><BR>What country are you in? Or, more importantly, what country do you want to produce output *for*?<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts