I have a query that I need to pull records added during the prior month. (The table stores date of each new record.) So I'd like for the user to NOT have to add a date range each month (more work and not goof proof) when he/she runs the query. Does anyone know the code I'd use in the query to set the range based on "between" the first and last days (including those dates) for the prior month? Sounds simple but...

I am not sure if you want a worksheet function or a VB cide solution but for the worksheet use

=EOMONTH(NOW(),-1) for the the end date (last day of previouse month)

and

=EOMONTH(NOW(),-2)+1 for the start date; (first day of previous month)


In code the following will do the same job

Sub SetDates(ByRef dStart As Date, ByRef dEnd As Date)

dEnd = DateAdd("d", -Day(Date), Date)

dStart = DateAdd("d", -Day(dEnd), dEnd) + 1

End Sub

Hope this coveres it

MTB