Date() !

Results 1 to 2 of 2

Thread: Date() !

  1. #1
    Join Date
    Dec 1969

    Default Date() !

    Hi,<BR><BR>I am trying to send a date from a server to an access DB using the following SQL in my ASP :<BR>Insert into Table(DateFld) Values (#"&Date()&"#)<BR><BR>The problem is that the date is been sent in DDMMYY format when in fact I need it in MMDDYY format....This causes the error message from access "Can&#039t Forward Date" as it thinks <BR>1570 is 07150....<BR><BR>Any ideas on how I can rejig this !

  2. #2
    Join Date
    Dec 1969

    Default RE: Date() !

    You might check how the system date/time environment is configured on the server you are using. It may be set to return dd/mm/yy... the Date() function returns the system date I think so the problem may be there. Or possibly try the Now() function...may produce the same results though. I&#039d check to see how the server is configured first (control panel/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