Forum Discussion
Solved
PeriodFilterTable PriorYear
Found a PeriodFilterTable to which I needed to add Prior Year. Added code is giving me the full prior year and the first day of the current year...I need only the prior year dates to output. Please advise.
Before the last comma insert "-1"
2 Replies
Before the last comma insert "-1"
That's what I had tried, but didn't work...then I realized, after recieving your response that TodaysDate was not just a date, but a datetime zone so I used...
{"Prior Year",
Date.AddYears(Date.StartOfYear(TodaysDate),-1),
Date.StartOfYear(TodaysDate) - #duration(0,0,1,0),
8}And that worked.
