Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I am currently struggeling with the FirstWorkDate Function.
I am Using
FirstWorkDate(last_data,5,vPublicHolidays)
where last_data is 06.05.2018.
in vPublicHolidays the 01.05.2018 is contained (and it does work in NetWorkDays just fine, I checked that).
The function returns 30.04.2018 but it should be the 27.04.2018, right? (04.05, 03.05, 02.05, 30.04. 27.04.)
Also I had lasta_data as 07.05.2018 and it returned 01.05.2018 which is a specified holiday...
When i am not using the varaible "vPublicHolidays" and only specify 1.5. with makedate it works. But as I said May has 19 Workdays according Net Workdays which uses vPublicHolidays.... (which is correct)
Does anyone know, whats happening there?
Best Regards
Max
Ok, I found it myself.
I have to put $(vPublicHolidays)
Can someone explain why this is necessary?
I am getting 27.04.2018. Could it be a formatting issue? Please check and ensure all dates you are using are in same format.
Ok, I found it myself.
I have to put $(vPublicHolidays)
Can someone explain why this is necessary?
That is probably because, your variable has got a definition and not the date values directly entered, and if that is true, it would require to be expanded (using dollar sign) to get the value in it.