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 @brokinsa23 ,
Thanks for your solution but I got much more optimized way for this problem.
let vToday = Today();
LET vQuarterEndDate = QuarterEnd('$(vToday)',-1);
Let vDelay1 = $(vDelay);
Let vDelayDate = Date(LastWorkDate('$(vQuarterEndDate)'+1,'$(vDelay1)'));
Load
if(('$(vToday)'= WeekDay('$(vToday)') or '$(vToday)' <> WeekDay('$(vToday)')) and '$(vToday)' <= '$(vDelayDate)',
QuarterEnd('$(vToday)',-1),
'$(vToday)'
) as EndResult
Resident MainTable;
Hi @brokinsa23 ,
Thanks for your solution but I got much more optimized way for this problem.
let vToday = Today();
LET vQuarterEndDate = QuarterEnd('$(vToday)',-1);
Let vDelay1 = $(vDelay);
Let vDelayDate = Date(LastWorkDate('$(vQuarterEndDate)'+1,'$(vDelay1)'));
Load
if(('$(vToday)'= WeekDay('$(vToday)') or '$(vToday)' <> WeekDay('$(vToday)')) and '$(vToday)' <= '$(vDelayDate)',
QuarterEnd('$(vToday)',-1),
'$(vToday)'
) as EndResult
Resident MainTable;