Forum Discussion

diogobraga2's avatar
diogobraga2
Icon for Helper IV rankHelper IV
6 years ago

Remove values after current date from previous years

The goal is to remove values after current date (most recent in this sample) from previous years for comparison purposes. Any insights?
Need Help
diogobraga2's avatar
diogobraga2
Icon for Helper IV rankHelper IV
6 years ago

JarroVGIT  thanks for the prompt reply. For the date fields in the calcuation, do I have to use the Calendar table? Right now I am, and I am getting the error message below. What do you think is going on? 

 

diogobraga2's avatar
diogobraga2
Icon for Helper IV rankHelper IV
6 years ago

JarroVGIT ,  MonthDay is being calculated the way you suggested. See below.