This query doesn't take into account the time the job ran - if there is more than one run in a day we have not specified how we want this...

Yay! 😀 I will keep my eyes peeled for it!

Is there a date for this yet?

So how about the below instead? Is there an overhead doing it this way?

--example table with dates to sort by Fin Year and Fin Quarter

CREATE TABLE #DatesToTest

(

TestDate DATE NOT NULL

,FinYear...

Maybe I'm just being a bit dense but I would rather use the below script to generate instead of relying on the datediff function and working back from today's date......