Confused about Date Formats

Results 1 to 3 of 3

Thread: Confused about Date Formats

  1. #1
    polarbear Guest

    Default Confused about Date Formats

    Hi,<BR><BR>I am currently using MS Access as the database for my ASP scripts and need the use of dates. I will like to know what I can do to allow the display of 4 digit year format on my webpages. Currently, I specified &#039mm/dd/yyyy&#039 as the field format, but the webpage does not display the year in 4 digits although the display in the MS Access itself does.<BR><BR>Thank you.

  2. #2
    Join Date
    Dec 1969

    Default RE: Confused about Date Formats

    That&#039s just due to the VBScript date formatting. You can use the FormatDateTime function (see or, for a very versitile date formatting function, use the code available at:<BR><BR><BR><BR>Happy Programming!

  3. #3
    Join Date
    Dec 1969

    Default RE: Confused about Date Formats

    In your regional settings (in control panel), you can set how dates appear on your PC, and how the short date format appears etc.<BR><BR>Since the date will be generated on the server side, you should check how the server displays dates by looking at its regional settings.

Posting Permissions

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