Forum Discussion

Qrew Cadet

3 years ago

Formula Query - How to return values within a Quarter or summarize data within a Quarter?

Hi, Is there a way to build a query that follows this function, but for quarters, not year? var text QUERY = "{7.OAF.'" & FirstDayOfYear([Month]) & "'} AND {7.OBF.'" & LastDayOfMonth([Month]) & ...

formula queries

MarkShnier__You

Qrew Legend

The LastDayofPeriod functions would not be used for calendar Months. those are typically used for 2 week payroll cycles for example.

Since you already have a field say fid 99 for the Quarter, you can just add in an extra AND to your query

AND {99.EX.'" & [Quarter] ....

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

JenniferJuhasz

Qrew Cadet

3 years ago

Hi Mark,

This worked perfectly! Thank you!! Eventually I'll get the hang of these formula queries... I appreciate your help.

Jen

------------------------------
Jennifer Juhasz
------------------------------