AmberGartner
3 years agoQrew Cadet
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 doing a backwards running total, so March is including April and March. Feb is including Feb, March and April. Thank you!
Thanks again!
------------------------------
Amber Gartner
------------------------------
var text query ="{48.OAF.'"&FirstDayOfMonth( [date field] )&"'} OR {48.OAB.'"&LastDayOfMonth ( [date field] )&"'} ";
Size(GetRecords($query))
Thanks again!
------------------------------
Amber Gartner
------------------------------