Skip to content
Advertisement

Generate list of all dates between x & y

I am tyring to use a solution I found online to generate a table of all dates between yesterday and Jan 1st of the prior year.

I’m getting errors on the 3rd line since i’m not sure how to dynamically build the right date for prior year that I want. If the query were to run today I would expect a list of all dates from Jan 1st 2019 to Apr 16th 2020

Advertisement

Answer

Hmmm . . . Does this work?

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement