finding yesterday

Results 1 to 2 of 2

Thread: finding yesterday

  1. #1
    Join Date
    Dec 1969

    Default finding yesterday

    is there an easy way to find yesterday using datetimeformat?<BR><BR>i&#039;m searching a file to see if today exists, and if it doesn&#039;t then i want it to look for yesterday, and so on and so on (datetime format is 05/07/2001). before i delve into breaking the date time down as a string, i thought i&#039;d check and see if there&#039;s a simple way to do this that i have overlooked.<BR><BR>thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: finding yesterday

    You can use the DateAdd function to do this. For the complete description of this command, go to<BR><BR>dateYesterday = DateAdd("d", -1, Now())<BR><BR><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