Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
Just wondering if there were some creative minds. I'm trying to figure out a way that wont break every year for having a variable that is for the current fiscal week. If our fiscal year was jan 1 it would be easy with week(today()). Our fiscal year starts feb 1 though and ive just tried adding days and such but it doesn't seem very robust. Any ideas?
I solved it but you have to load it in the script with your dates table
if("DATES_ISO_DATE"=today(),"DATES_FISCAL_WEEK")as "Current Fiscal Week Flag",
I have an Iso Dates field that is the same format as today() and was trying something like the following:
=if(today()=DATES_ISO_DATE, FW) but it doesn't work.
I solved it but you have to load it in the script with your dates table
if("DATES_ISO_DATE"=today(),"DATES_FISCAL_WEEK")as "Current Fiscal Week Flag",