Formatting dates

Results 1 to 2 of 2

Thread: Formatting dates

  1. #1
    Alastair Moore Guest

    Default Formatting dates

    Hello all,<BR><BR>Got a bit of a problem with formatting dates. Basically I&#039ve got a form which a user enters a date in, which is in a non-US format (DD/MM/YY). When I store the date in the Access database, it comes up with an error due to the database requiring the date to be in US format. Can someone feed me a function which will convert to UK/Australia format? Or is there a function already available? Secondly, can you advise your government to change your date format to one the rest of the world is using, then I won&#039t get problems like this! :) Cheers!<BR><BR>Al

  2. #2
    Join Date
    Dec 1969

    Default RE: Formatting dates

    Al,<BR>You need to change your database. In design Veiw Choose your date field then select &#039Format&#039 type in this dd/mm/yy and save.<BR>This will maintain the state of your date. <BR><BR>cheers

Posting Permissions

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