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

To make sure I understand you correctly, are you looking for a way to calculate the first Monday of December based on a given year using SAIL?

Hi Nick,
The requirement is right. But I am looking for any way of expression rule to accomplish this, not in SAIL.

Thanks,

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.

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.

Thank Stefan for your initial idea and Thank Nick for your for implementation.
Henry