comparing dates

Results 1 to 2 of 2

Thread: comparing dates

  1. #1
    Join Date
    Dec 1969

    Default comparing dates

    Hi,<BR><BR>When I write the following:<BR><BR>&#060;%= DateSerial(Month(date),Day(date),Year(date))%&#062 ;<BR><BR>the returned value is 9/25/2015. Can anyone explain what I&#039;m doing wrong? My goal is to compare today&#039;s date with the last time a form was submitted. Thanks-

  2. #2
    Join Date
    Dec 1969

    Default Read the docs...

    ...on DateSerial again!<BR><BR>There is ONLY ONE order that you can specify the arguments in.<BR><BR>HINT: It is *NOT* DateSerial( month, day, year )<BR><BR>Bigger HINT: It *is* DateSerial( year, month, day )<BR><BR>Interesting result you got.<BR><BR>You were, effectively, giving DateSerial a value of<BR> year = 10<BR> month = 4<BR> day = 2004<BR><BR>Can you figure out why you got the results you did, from that?<BR><BR>HINT: Read the docs.<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