Forum Discussion

LoriPelzel's avatar
LoriPelzel
Qrew Member
3 years ago

Need help with a formula that is asking for last year

var date datevariable = AdjustYear([WTF],-1); SumValues(GetRecords("{9.EX.'"& [Distributor] &"'} AND {12.EX.'"& [Manufacturer] &"'} AND {11.OAF.'"& $datevariable &"'} AND \n {11.OBF.'"& [WTF] &"'}"...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
try this change

var date datevariable = AdjustYear(FirstDayOfYear([WTF]),-1);

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
LoriPelzel's avatar
LoriPelzel
Qrew Member
3 years ago
Thanks for the quick response, I will try it tomorrow at work.
Lori