Please help...new to access. However I understand the function at hand,but cannot get it to work. I need to add working days between these dates. So I used the 'w' function in the below statement, however it is working the same as 'd'. HELP!!
Here is my function below:
EDL HP PO Due Date: IIf([VENDOR]=Yes,DateAdd("w",[tbl_Turnaround Schedule]![Turnaround Time],[ExFactory Date]),IIf([tbl_Master Data Table]![HP Business Unit]="ESS",DateAdd("w",4,[ExFactory Date]),DateAdd("w",5,[ExFactory Date])))
Here is my function below:
EDL HP PO Due Date: IIf([VENDOR]=Yes,DateAdd("w",[tbl_Turnaround Schedule]![Turnaround Time],[ExFactory Date]),IIf([tbl_Master Data Table]![HP Business Unit]="ESS",DateAdd("w",4,[ExFactory Date]),DateAdd("w",5,[ExFactory Date])))