Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all experts.
I have a table with the field THE_DATE format 'YYYYMMDD' but it was save as string.
I want to count network days in the script.
how can I do that?
In the chart after I load the table it is working.
NetWorkDays(date(MakeDate(left(min(THE_DATE),4),right(left(min(THE_DATE),6),2),right(min(THE_DATE),2)),'DD/MM/YYYY'),
MonthEnd(date(MakeDate(left(max(THE_DATE),4),right(left(max(THE_DATE),6),2),right(max(THE_DATE),2)),'DD/MM/YYYY')))
But I want to do it in the script level.
any idea?
BR
Ariel
Something like this:
load
networkdays(date#(THE_DATE,'YYYYMMDD'),monthend(date#(THE_DATE,'YYYYMMDD'))) as NetDays
from ...somewhere...;
Something like this:
load
networkdays(date#(THE_DATE,'YYYYMMDD'),monthend(date#(THE_DATE,'YYYYMMDD'))) as NetDays
from ...somewhere...;
Hello Ariel,
All the functions you used are supported in script as well. So, Can you please explain what is the real concern you are having?
Hi G
Thanks for your answer.
It is working.