I am comparing yesterday to the same day last year and am trying to find a better way to achieve this. At the moment I am using select in field for 'week of year' and 'day of week'r. This falls over at this time of year though as Week 52 or Week 1 does not cross over between years.
At some stage I will need to look into the fault in the calendar but for the moment I just need a workaround. I know if I manually select the two dates I am interested in it works but as the select in field is part of an automatic process I need to set this up as a trigger.
So far I have got max(FullDate) and max(FullDate)-364 working individually but how do I combine these into a single trigger?