Help with Date()

[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

 

[fredg]

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

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

 

[Avid Reader]

Wow!!! that simple.

Thanks once again.

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