Displaying date problems

Results 1 to 4 of 4

Thread: Displaying date problems

  1. #1
    jimmr Guest

    Default Displaying date problems

    I&#039;ve set my Access DB field to date and formatted for long dates eg 19 July 1999. When displayed in asp it shows up as 7/19/1999. How can I display it as it is in database?<BR><BR>Secondly, how do I display it in date order? At the moment it displays date&#039;s as they are entered.

  2. #2
    Tim Snyder Guest

    Default RE: Displaying date problems

    Display is a VB format issue Assuming your ASp pages are VB<BR>FormatDateTime(Now(), vbLongDate)<BR>substitute Now() with the datafield and your home and dry

  3. #3
    jimmr Guest

    Default RE: Displaying date problems

    Excuse my ignorance but where would I put this statement? Does it go in my response.write statement? eg<BR>Response.Write "&#060;tr&#062;&#060;td bgcolor=&#039;#CCCC99&#039;&#062;" & objRS("register_date") & "&#060;/td&#062;"

  4. #4
    Tim Snyder Guest

    Default See


Posting Permissions

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