Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have a Quarter End Date. And I want to repeat that date till the next delayed days.
ONLY WORKDAYS SHOULD BE CONSIDERED FOR DELAY DAYS.
Can you help me for this.
Thanks in advance.
Hi Community,
I got the answer.
let vToday = Today();
LET vQuarterEndDate = QuarterEnd('$(vToday)',-1);
Let vDelay1 = $(vDelay);
Let vDelayDate = Date(LastWorkDate('$(vQuarterEndDate)'+1,'$(vDelay1)'));
MainTable:
Put your data here....
Output:
Load
if(('$(vToday)'= WeekDay('$(vToday)') or '$(vToday)' <> WeekDay('$(vToday)')) and '$(vToday)' <= '$(vDelayDate)',,
QuarterEnd('$(vToday)',-1),
'$(vToday)'
) as EndResult
Resident MainTable;
This is the solution. Thank you
Hi Community,
I got the answer.
let vToday = Today();
LET vQuarterEndDate = QuarterEnd('$(vToday)',-1);
Let vDelay1 = $(vDelay);
Let vDelayDate = Date(LastWorkDate('$(vQuarterEndDate)'+1,'$(vDelay1)'));
MainTable:
Put your data here....
Output:
Load
if(('$(vToday)'= WeekDay('$(vToday)') or '$(vToday)' <> WeekDay('$(vToday)')) and '$(vToday)' <= '$(vDelayDate)',,
QuarterEnd('$(vToday)',-1),
'$(vToday)'
) as EndResult
Resident MainTable;
This is the solution. Thank you