Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Users,
I am using the following code
NetWorkDays(Sales_Mis_SALES_LOGIN_DATE,Sales_Mis_SANCTION_DATE,$(vHoliday)) as SANCTION_DAYS
I wanna pass mutiple days in vHoliday but i am not getting desired result,
vHoliday='11/11/2015','12/11/2015'
Request you to help.
Or Just suitable option to achieve thi I have set of 10 dates which should be avoided for calculation of sanction days.
Thanks and Regards,
Rohit
See if this helps:
vHoliday= Chr(39) & MakeDate(2015, 11, 11) & Chr 39, Chr(39) & MakeDate(2015, 12, 11) & Chr 39
Good Explanation in the Below Document.
try to provide Numbers instead of actual date in variable. for example 42326
I have tried using this but it only accepts one date..
Are the dates in fields of similar formats? If so, try