Previous month end business day in Query

  • Thread starter dodat via AccessMonster.com
  • Start date
D

dodat via AccessMonster.com

How do I set the previous month end business day so I do not have to type it
in each time I run a macro.

For example, I have 15 queries that require this field and I do not want to
prompted to type in 11/30/2006 15 times.

Thanks in Advance.
 
J

John Spencer

Use
DateSerial(Year(Date()), Month(Date()), 0)

That calculates the last day of the month prior to the current month. The
Zero-th day of a month is one less than the 1st day of a month.
 
Top