AnsweredAssumed Answered

Same Date Last 1/2/3 Year(s) Ago

Question asked by NickUlrich on Feb 14, 2014
Latest reply on Apr 4, 2017 by GoogleMac


Same Date Last 1/2/3 Year(s) Ago


     Hey all,

     I need to calculate the same day of the week from a prior year to compare the revenue generated on those days... Is this simply a matter of Date-364, Date-728, Date-1092, etc, etc? I would effectively want to compare the same Monday's vs Monday's, Tuesday's vs Tuesday's, etc.

     Theoretically, this makes sense to me, but comparing the WeekOfYear, it seems to break down, the further back I would go.

     Hoping somebody has some thoughts or advice on this.

     Thanks in advance!