6 months ago

V

Van T. Dinh

SELECT *
FROM YourTable
WHERE [DateField] BETWEEN DateAdd("m", -6, Date()) AND Date()
 
D

Dan Artuso

Hi,
Use the DateSerial function.
6 months ago would be:
DateSerial(Year(Date()),Month(Date()) - 6,Day(Date()))
 

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

Notes not showing up in Powerpoint Presenter Mode 0
Incone & Expenses Statement 0
CRM concept 0
Display weeks from a Milestone 0
Managing multiple jobs in a fabrication shop 0
Outlook 365 extremely stubborn 0
S.Y.M. Wong-A-Ton .... PLEASE HELP, I Need your INFOPATH 2013 COOKBOOK 2 1
Sum of Numbers of a Rolling 6 month Period range 0

Top