MS ACCESS Macro Condition on current date month = 01

By steveg ·
How do you set a condition on macro, which has a step for a report that you only want to run when the month is 01?

I've played around with Month(Date()) = '01' and similar with no success?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Try Month(Date())=1

by arkman In reply to MS ACCESS Macro Condition ...

01 is text but 1 is a number. I have just tried it with Month(Date())=7 and it works for me

Collapse -

Still running step

by steveg In reply to Try Month(Date())=1

Since current month is 7, try 1 and see if it runs still for you (it shouldn't). It did for me. Access97 SP3

Collapse -

It didn't run with 1

by arkman In reply to Still running step

I tried 1 and it didn't run for me. I have Access 2003 SP3 - sorry it didn't work for you. I'll give it another look

Related Discussions

Related Forums