Forum Discussion
Solved
User entered date with comparison column for previous year
I am trying to have a custom date range that the user can enter dates and I want a column that shows the values for that current date range and a second column that shows the values for that month/da...
How do you prevent the user from selecting a range that reaches across years? What should happen if they select 2022-10-01 to 2023-02-28 ?
See attached for a standard approach using SAMEPERIODLASTYEAR
lbendlin
Super User
Super UserHow do you prevent the user from selecting a range that reaches across years? What should happen if they select 2022-10-01 to 2023-02-28 ?
See attached for a standard approach using SAMEPERIODLASTYEAR
