473,848 Members | 1,628 Online

# End of month date calculation

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(DateSer ial(year(Date() etc but I can't figure it out. Thanks,

--
Message posted via http://www.accessmonster.com
Mar 28 '06 #1
2 6789
"smcgrath via AccessMonster.c om" <u10749@uwe> wrote in message
news:5df0b1bb19 a5d@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(DateSer ial(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
smcgrath via AccessMonster.c om 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(DateSer ial(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 thread has been closed and replies have been disabled. Please start a new discussion.