Forum Discussion
Weekday Last Year Comparison
Hi everybody ! I have a requeriment that i don't know how to achieve. Question is simple, how can I compare this year sales with exactly the same weekday sales of last year. take for instance, To...
Hi Vvelarde, yep you're right it was 3th July 2015 I confused it with August.
About your answer, It work for this year, but what happen if the year is a leap-year? It has 366 days and a normal year has 365. It have to be dynamic or something like that. My solution have to work to infinity and beyond
Hi
A leep year still has 52 weeks so you will hit the same weekday.
But in years with 53 weeks you have to decide whether you want to go 364 days (52*7) back or (53*7) - the easy way is always to use 364 (52*7) :-)
br
Erik