AnsweredAssumed Answered

How to Check if a Date Falls Within a Range

Question asked by koolgeex on May 25, 2016
Latest reply on May 25, 2016 by cazza162

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???

Outcomes