Hi - I'm trying to add our Fiscal Weeks to a Saved...
# general
e
Hi - I'm trying to add our Fiscal Weeks to a Saved Search. I tried using the "week of year" function but it's pulling Jan. 1st as Week1 and our fiscal starts on Sept. 1st. We have our Accounting Periods set for the full year. Does anyone know how to change the "start" date of the Week of Year feature? Thank you!
w
I'd try to use a formula to offset the date and then use a to_char({the offset date}, ’YYYY-IW’) or similar
Perhaps use add_months({trandate},9)