Fiscal week variable of today (fiscal year starts feb 1st)

[#1]

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?

[#2]

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. 

[#3 · Accepted solution]

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",