I have a workflow that I need to edit but I'm not sure which action to use.
I have a two columns - Approval Date (column type = date/time) and Fiscal Year (column type = single line text).
If the date in the approval date column falls between a certain range, I want to update the Fiscal Year column to reflect that.
Example: Approval Date = 05/15/2016, Is Approval Date between 09/01/2015 and 08/31/2016?, If yes, update Fiscal Year column. If no, do nothing.
Can anyone point me in the right direction???