Retieving Transaction from Last Month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I'm building a query that will be retrieving transactions from the previous
month the Entire process will be automated and ran once a month.

I thought of the DateDiff function, but I'm kinda lost.

Any help?
 
Yes, i think u should use DateAdd function
DateAdd("m", -1, "01/01/2006")

first parameter can be d,m, or y (day,month or year)
second parameter the number you wanna add or subtract
third, the day ur gonna add to or subtract from
 
You must log in or register to reply here.

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

Apply Month End date based on transaction date 5
query not showing all data for last month 3
Creating a table of summaries by month...? 1
finding last transaction in month 12
Updating Fiscal month field value based on transaction date 1
Compare current month totals with last months totals 1
ACC2K3: Multi-table Update Transactions Are Unreliable 11
retrieving previous year and month 1

Back
Top