Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Can anyone correct the syntax?
networkdays(date#([As of Date],'MM-DD-YYYY'), date#([Creation Date],'MM-DD-YYYY'))
Thanks in advance!
Regards,
Varun
if you have text fields as in
=networkdays(date#('01-01-2015','MM-DD-YYYY'), date#('03-01-2015','MM-DD-YYYY'))
your expression should worh
if you have date fields
networkdays([As of Date], [Creation Date])
Are you getting syntax error?
I am not getting any output.
how you are using it? Provide sample script..
I actually want to get number of business days between [As of Date] and [Creation Date]
Would you mind posting a sample of your app?
If your dates are in 'MM-DD-YYYY' then format is appearing correct. If dates are not in the used format then you need to use - date(date#([As of Date],'<input date format'),'MM-DD-YYYY')
if you have text fields as in
=networkdays(date#('01-01-2015','MM-DD-YYYY'), date#('03-01-2015','MM-DD-YYYY'))
your expression should worh
if you have date fields
networkdays([As of Date], [Creation Date])
You will get it... But before that we need some input from you... Can you please provide the script which you are using?
Hi Manish,
I don't have access to send you the application
Thanks & Regards,
Varun