Hi All,
Is there any function in Appian to check if date exist between 2 dates period?
Thank you
Discussion posts and replies are publicly visible
How about something as simple as and( ri!myDate > ri!startDate, ri!myDate < ri!endDate ) ?
This routine should return either true or false. "date1" and "date2" are just examples. On this case, it will return true.
The last line, should be the snippet that you can use.
with ( local!date1: today(), local!date2: today() + 2, tointeger(local!date2 - local!date1) > 0 )