query only current day and current day in the past 1

[itechC]

hello,

I would like to create a query that will give me results for current day (example may 7) and also every 7 th of the month previous. Much appreciated.

Frank

 

[PHV]

SQL code snippet (WHERE clause):

WHERE [your date field] IN (Date(),DateSerial(Year(Date()),Month(Date())-1,Day(Date())))

Another way:

WHERE [your date field] IN (Date(),DateAdd('m',-1,Date())

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PHV]

OOps, you said every:

WHERE Day([your date field])=Day(Date()) AND [your date field]<=Date()

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[itechC]

Thanks works great!