AnsweredAssumed Answered

Comparing previous years but same DOW

Question asked by jhaupt on Oct 11, 2018
Latest reply on Oct 12, 2018 by user19752

Good day everyone,

 

I'm trying to find a way to look up a field from 1 year ago (ex: Daily sales) and have it auto-enter on the new record.  But I need the formula to compare it to the same day of the week of the previous year i.e. Saturday to Saturday.

 

For example I would want to fetch the value from Thursday, October 12th, 2017 and auto-enter to the new record that is created on Thursday, October 11th, 2018.

 

Will this solution account for leap years?

 

 

Thanks so much!!!

 

James

Outcomes