iff(datepart..

[pranvera]

Hello guys,



this formula makes filter which select date older than 3 working days without limit.

<= iif(datepart("w",date()) <=4 ,date()-5,date()-3)

Can you please help me how to update formula to include a bottom limit ?

I need to have dates older 3 days ( same as it is now) and not older 5 days ( must not count weekends)


if you have any idea plese help me.

thanks!

[weekend00]

<= iif(datepart("w",date()) <=4 ,date()-5,date()-3) and >= iif(datepart("w",date()) <=4 ,date()-7,date()-5)

[pranvera]

<= iif(datepart("w",date()) <=4 ,date()-5,date()-3) and >= iif(datepart("w",date()) <=4 ,date()-7,date()-5)

thank you for so fast answer man. It says syntax error can you please check if that is correct ?

FROM DailyMar
WHERE (((DailyMar.[Move Status])="mvng") AND ((DailyMar.[Req Delivery Dt/Tm])<= iif(datepart("w",date()) <=4 ,date()-5,date()-3) and >= iif(datepart("w",date()) <=4 ,date()-7,date()-5)));

[weekend00]

should read like these,please recheck the "(" and ")":
WHERE (((DailyMar.[Move Status])="mvng") AND ((DailyMar.[Req Delivery Dt/Tm])<= iif(datepart("w",date()) <=4 ,date()-5,date()-3) and (DailyMar.[Req Delivery Dt/Tm])>= iif(datepart("w",date()) <=4 ,date()-7,date()-5)));

[pranvera]

yes, perfect !!

thank you a lot!