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
------------------------------
  • AmberGartner's avatar
    AmberGartner
    Qrew Cadet
    4 years ago
    I think I may have replied to you directly before somehow... but I did update the OAB to OBF -- THANK YOU for that. I had to keep in the FirstDayOfMonth formula in order for it to work, but then also changing the OR (back) to AND worked as well. So again, thank you thank you!!

    ------------------------------
    Amber Gartner
    ------------------------------