Hi all, Is there any quick way to get date value when it is specified in re

henryd over 9 years ago

Hi all,
Is there any quick way to get date value when it is specified in recurring format calendar? For example, the first Monday of December of each year.

Thanks.

Discussion posts and replies are publicly visible

Parents

0 Nick Vigilante
Appian Employee
over 9 years ago

Please test this out:

if(
weekday(date(ri!year, 12, 1), 3)=0,
date(ri!year, 12, 1),
if(
weekday(date(ri!year, 12, 2), 3)=0,
date(ri!year, 12, 2),
if(
weekday(date(ri!year, 12, 3), 3)=0,
date(ri!year, 12, 3),
if(
weekday(date(ri!year, 12, 2), 4)=0,
date(ri!year, 12, 4),
if(
weekday(date(ri!year, 12, 5), 3)=0,
date(ri!year, 12, 5),
if(
weekday(date(ri!year, 12, 6), 3)=0,
date(ri!year, 12, 6),
date(ri!year, 12, 7)
)
)
)
)
)
)

You must create one rule input which is an integer that takes the year you specify.

Hope this helps.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Nick Vigilante
Appian Employee
over 9 years ago

Please test this out:

if(
weekday(date(ri!year, 12, 1), 3)=0,
date(ri!year, 12, 1),
if(
weekday(date(ri!year, 12, 2), 3)=0,
date(ri!year, 12, 2),
if(
weekday(date(ri!year, 12, 3), 3)=0,
date(ri!year, 12, 3),
if(
weekday(date(ri!year, 12, 2), 4)=0,
date(ri!year, 12, 4),
if(
weekday(date(ri!year, 12, 5), 3)=0,
date(ri!year, 12, 5),
if(
weekday(date(ri!year, 12, 6), 3)=0,
date(ri!year, 12, 6),
date(ri!year, 12, 7)
)
)
)
)
)
)

You must create one rule input which is an integer that takes the year you specify.

Hope this helps.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data