Access Macro Condition 2

[Mike555]

I have an autoexec macro that opens 2 reports automatically when the db is opened. I'm trying to setup a 3rd report to open automatically, but it should open only if the date is between 12/31 - 01/31. The expression I've created below doesn't work.

Now() >= 12/31 and <= 01/31

Thanks.

 

[GingerR]

do you mean only if the month is january?
of any year? or just this year?
it's reading your '12/31' and '01/31' as text. you have to put # around a date so it reads it as a date:

if you just want it to be january of any year:

Month(Date()) = 1

otherwise use this type of format:

Date() between #1/1/03# and #12/31/03#

or if you mean &quot;in between 12/31 of last year and 1/31 of this year&quot; then use this:

Date() between cdate("12/31/"&year(Date())-1) and cdate("1/31/"&year(Date()))

 

[Mike555]

Month(Date()) = 1 is what I needed. Thanks!!!