Calculate Previous Year to Date (YTD)

Let’s say you’re looking to find metrics for the previous year to date.

For the first day of the previous year, you can use MakeDate like so: MakeDate(Year(Now())-1, 1, 1).

To find the current date of the previous year, use DateAdd like so: DateAdd("year", -1, DateTrunc("day", Date(Today()))). This truncates the current date by day and uses DateAdd to subtract it by one year.

Now, if you are looking for any previous YTD calculations, simply use Between with the two dates:

Between([Date Column], MakeDate(Year(DateAdd("year", -1, Today())), 1, 1), DateAdd("year", -1, DateTrunc("day", Date(Today())))