Help with Date()

  • Thread starter Thread starter Avid Reader
  • Start date Start date
A

Avid Reader

Hi all,

I have a query that runs based on yesterday's date.

So I use the command Format(Date(),"yyyymmdd")-1 which works fine until I
get to the end of the month then all is screwed up.

Like today, with the date function that I'm using above will produce
something like 20060600, instead of the intended date of 20060531.

I'm guessing that this would be somewhat of an easy fix and appreciate all
the help.

Thanks


Antonio
 
Hi all,

I have a query that runs based on yesterday's date.

So I use the command Format(Date(),"yyyymmdd")-1 which works fine until I
get to the end of the month then all is screwed up.

Like today, with the date function that I'm using above will produce
something like 20060600, instead of the intended date of 20060531.

I'm guessing that this would be somewhat of an easy fix and appreciate all
the help.

Thanks

Antonio
Click to expand...

Format(Date()-1,"yyyymmdd")
 
Back
Top