Forum Discussion

AmberGartner's avatar
AmberGartner
Qrew Cadet
4 years ago

Query to find all records that have a date field in the same month

Can anyone help me figure out how to query to find all the records that have a certain date field that's in the same month (and year)? This is what we have, and it's correct for April, but then it's d...
formula queries
Formulas and functions
JeffPeterson1's avatar
JeffPeterson1
Qrew Captain
4 years ago
It should be like this:

var text QUERY = "{48.OAF.'" & [Date Field] & "'}AND{48.OBF.'" & LastDayOfMonth([Date Field]) & "'}";

Keep in mind that if your [Date Field] is a date/time field you'll need to convert it using ToDate()

Also you have 'OAB' instead of 'OBF' in your query.

------------------------------
Jeff Peterson
------------------------------