Query 3 months back, I have the name of the month there is no date added per request

[GinaFlan]

I am looking to query for 2 months back from the current month including the current month's data, my data entry however is by the for the month of (the name of a month). I did by the name of the month per request.




Is there any chance I can code it? I found the code below.


DateDiff("m", -3, Date()) and Date()



BETWEEN DateSerial(Year(Date()),Month(Date())-3,1) ANDDateSerial(Year(Date()),Month(Date()),0)

[GinaFlan]

I realized I would have to use MonthName() it's probably not possible I am guessing