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

henryd over 8 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 Stefan Helzle
A Score Level 3
over 8 years ago

I think there is no direct way, but you can start with the the first day in that month, then check which weekday that is and add a few days.

I did a quick test for this expression

=with(
local!start: date(year(ri!date), month(ri!date), 1),
local!wDay: weekday(local!start, 2),
local!start + day() * (8-local!wDay)
)

It might be not perfect but should help you getting started.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Stefan Helzle
A Score Level 3
over 8 years ago

I think there is no direct way, but you can start with the the first day in that month, then check which weekday that is and add a few days.

I did a quick test for this expression

=with(
local!start: date(year(ri!date), month(ri!date), 1),
local!wDay: weekday(local!start, 2),
local!start + day() * (8-local!wDay)
)

It might be not perfect but should help you getting started.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data