Forum Discussion

MODUser's avatar
MODUser
Frequent Visitor
2 years ago
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 a...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Before the last comma insert  "-1"

lbendlin's avatar
lbendlin
Super User
2 years ago

Before the last comma insert  "-1"

  • MODUser's avatar
    MODUser
    Frequent Visitor
    2 years ago

    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.