Syntax to Compare Dates

[ddevil]

I have the following date comparison:

If stStat2 = "Open" And Year(stSchedDate) > Today Then

do something.....

What I really want is if the stSchedDate > the beginning of the month prior to the month we are in.

If the stSchedDate was 11/24/2008 then this statement would be true because the begining of the month prior to December, the month we are in, would be 11/1/2008.

Any ideas what the syntax would be for this?

 

[MichaelRed]

see DateAdd in the ubiquitous "help" (aka "F1")



MichaelRed

 

[JBinQLD]

G'day ddevil,

stSchedDate = DateAdd("d",1-Day([stSchedDate ]),DateAdd("m",-1,[stSchedDate ]))

will set stSchedDate to the 1st of the previous month. Also will work over 08/09 boundaries which could be a drama with your month() plan...

Good luck!

JB

 

[PHV]

if the stSchedDate > the beginning of the month prior to the month we are in
If stStat2 = "Open" And stSchedDate > DateSerial(Year(Now), Month(Now) - 1, 1) Then

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886