By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,570 Members | 970 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,570 IT Pros & Developers. It's quick & easy.

End of month date calculation

P: n/a
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
Mar 28 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"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
Mar 28 '06 #2

P: n/a
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
Mar 28 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.