De-Increment Month Value by 1

  • Thread starter Thread starter Attila Fust
  • Start date Start date
A

Attila Fust

I have a query that returns dates. All of the dates are
the 15th of the month. I need to query so it will de-
increment the month by 1 month. For example, if the date
is 07/15/04 it need the query to return 06/15/04. I can
subtract 30 from the actual date but it won't always
return the 15th of the previous month.

There is a way to do this in Excel but I would like to do
it in Access. Is this easily done?

Attila Fust
 
Yes, using the DateDiff function. With DateDiff you can specify the
interval you want to subtract and month is one of those. Open a VB module
and look in Help for more specifics. Note: the Help in a VB module is
better and more specific to Access than the Help in the Access GUI..

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Thanks for your help. I actually used the DateAdd
function:

DateAdd ("M", -1, <date>) and it worked fine.

Attila
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mid-Month function help 3
Conditional Formatting based on dynamic Date 1
Access Count dates within a Month 4
Cross tab query solution 4
Count Records and Group by Month 4
query criteria between dates 2
Access Getting Month periods to show in ACCESS query as 0 when there is no data for the month 0
Date Brackets as an IIf statement 3

Back
Top