I'm performing a comparison between Todays month and the month an evaluation was submitted to a Sharepoint list.
The Month value is being written to the Sharepoint list with the function:
This results in "8" for August.
The comparison to the Sharepoint column is being done with this function:
This results in "08" for August.
The values do not compare correctly because of the "0" prefix the Text(Today function places in front of single digit months. To try and compare apples to apples, I wrapped the Month function in the Text function: