2 Replies Latest reply: Jun 5, 2012 10:32 AM by brandon breitling RSS

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

    brandon breitling

      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?