Acess 97 Date inconsistencies?

Results 1 to 2 of 2

Thread: Acess 97 Date inconsistencies?

  1. #1
    Join Date
    Dec 1969

    Default Acess 97 Date inconsistencies?

    If I use Response.Write (Date) I get 11/04/00 (April). But when I INSERT INTO my database, Access 97 converts it to 4/11/00 (November). 13/04/00 is OK since dd/mm/yy is obvious, how do I force the interpretation dd/mm/yy?

  2. #2
    Join Date
    Dec 1969

    Default RE: Acess 97 Date inconsistencies?

    Access will always insert the date like that.<BR>What you need to do is that when you get the date from the database again you need to change the date into dd/mm/ccyy<BR><BR>&#060;%<BR>dmy = rsTable("datefield")<BR>dayt = Day(dmy)<BR>montht = Month(dmy)<BR>jeart = Year(dmy)<BR>%&#062;<BR><BR>Now let say you want to write this date what you need to do is.<BR><BR>&#060;%<BR>dim datetest<BR>datetest = (dayt & "/" & montht & "/" & jeart)<BR>response.write datetest<BR>%&#062;<BR><BR>Hope that this helped you.<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