Forum Discussion
DougHenning1
3 years agoCommunity Manager
This should work- it adjusts the beginning date to the previous year if needed:
EDIT: Updated for missing $
------------------------------
Doug Henning
------------------------------
var text beginDate = IF(Month([Month]) < 9, "9-1-" & (Year([Month]) - 1), "9-1-" & Year([Month]));
var text QUERY = "{1.OAF.'" & $beginDate & "'}AND{1.OBF.'" & LastDayOfMonth([Month]) & "'}";āā
EDIT: Updated for missing $
------------------------------
Doug Henning
------------------------------
- MichaelPeoples3 years agoQrew MemberThank you very much Doug! That worked great...
For others who might use this formula I had to add a $ before the beginDate to apply the formula on my page. See the updated formula below.
var text beginDate = IF(Month([Month]) < 9, "9-1-" & (Year([Month]) - 1), "9-1-" & Year([Month])); var text QUERY = "{1.OAF.'" & $beginDate & "'}AND{1.OBF.'" & LastDayOfMonth([Month]) & "'}";āā
------------------------------
Michael Peoples
------------------------------