Forum Discussion
MarkShnier__You
3 years agoQrew 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
------------------------------
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
------------------------------
- JenniferJuhasz3 years agoQrew CadetHi Mark,
This worked perfectly! Thank you!! Eventually I'll get the hang of these formula queries... I appreciate your help.
Jen
------------------------------
Jennifer Juhasz
------------------------------