substact N working day from a date

[mohamed_ahid]

Hi all,

I'm facing a probleme with date .Let me explain :

i want to get the date of today  minus 20 working day (dont count sunday and saturday)

exemple :

for october  13 2014 - 20 = september 16 2014

Thx

[anbu1984]

Dt:

Load Date(Dt_Minus_20) Where DayDiff=20;

Load NetWorkDays(Dt-(20+IterNo()),Today()) As DayDiff,Today()-(20+IterNo()) As Dt_Minus_20 While IterNo() < 10 ;

Load

Today() As Dt

AUTOGENERATE(1);

[mohamed_ahid]

thx but i didn't get your idea .

[anbu1984]

Generate a row with today's date

Load

Today() As Dt

AUTOGENERATE(1);

NetworkDays function return number of days between two dates without including weekends. Following statement generate 9 rows from Today()-20( 22-09-2014) to 14-09-2014

Load NetWorkDays(Dt-(20+IterNo()),Today()) As DayDiff,Today()-(20+IterNo()) As Dt_Minus_20 While IterNo() < 10

Following statement picks date exactly 20 days from current day

Load Date(Dt_Minus_20) Where DayDiff=20;

[mohamed_ahid]

is there a way to do that on designer rather than developer ?

[anbu1984]

Test this expr

=Date(If(NetWorkDays(Today()-26,Today()) = 20,Today()-26,If(NetWorkDays(Today()-27,Today()) = 20,Today()-27,If(NetWorkDays(Today()-28,Today()) = 20,Today()-28))))

[jonathandienst · Accepted solution]

Hi

=FirstWorkDate(Date#('2013/10/13'), 20)

HTH

Jonathan

[mohamed_ahid]

Thanx Anbu and Jonathan you were GREAT.