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?
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?