End of month date calculation

[smcgrath via AccessMonster.com]

I have a table listing accounts with a closed date - our Trial balance drops
the account after 7 days but our database keeps the record forever - How do I
calculate the end of month less 7 days so that I can get an actual count of
the accounts that were closed during the month. I believe that the
calculation involves
Between(DateSerial(year(Date() etc but I can't figure it out. Thanks,

--
Message posted via http://www.accessmonster.com

[Fred Zuckerman]

"smcgrath via AccessMonster.com" <u10749@uwe> wrote in message
news:5df0b1bb19a5d@uwe...

I have a table listing accounts with a closed date - our Trial balance drops the account after 7 days but our database keeps the record forever - How do I calculate the end of month less 7 days so that I can get an actual count of the accounts that were closed during the month. I believe that the
calculation involves
Between(DateSerial(year(Date() etc but I can't figure it out. Thanks,

--
Message posted via http://www.accessmonster.com

This "quickie" may help,

Last day of previous month =
Date() - Day(Date())

Fred Zuckerman

[Rick Brandt]

smcgrath via AccessMonster.com wrote:

I have a table listing accounts with a closed date - our Trial
balance drops the account after 7 days but our database keeps the
record forever - How do I calculate the end of month less 7 days so
that I can get an actual count of the accounts that were closed
during the month. I believe that the calculation involves
Between(DateSerial(year(Date() etc but I can't figure it out. Thanks,

End of month minus 7 days would be...

DateAdd("d", -7, DateSerial(Year(Date()), Month(Date())+1, 0))

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com