dateformat, beginner's question

Results 1 to 2 of 2

Thread: dateformat, beginner's question

  1. #1
    Isabelle Guest

    Default dateformat, beginner's question

    Hi,<BR><BR>with the function &#060;%= date&#037;&#062;, you get the date formatted like "mm/dd/yy". How can I change this to "mm/dd/yyyy"?<BR>When I use this in a form to update an access database, do I have to change anything in the settings of Access?<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969
    Posts
    1,019

    Default RE: dateformat, beginner's question

    Check out the VBScript FormatDateTime Function at:<BR>http://msdn.microsoft.com/scripting/default.htm?/scripting/vbScript/doc/vsfctFormatDateTime.htm<BR>For Access, you want to make sure you are using any date format that has 4 digit years. If you&#039re doing this on your own Windows PC using a PWS, make sure you&#039ve changed your Regional Settings for a dates to 4 digit years. To do this go start, settings, control panel, Regional Settings and then click on the Date tab.

Posting Permissions

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