I have a date field named CRDATE, I need to write some script to tell me the number of working days between CRDATE and Today()...I'm struggling with the syntax, can anyone out there help me please?
Any help is greatly appreciated.
This should work as long as CRDATE is a date field and not a string: networkdays(CRDATE, today() ). If CRDATE is a string you first have to use the date# function to create a date from it.
Excellent, thanks for the help.
Retrieving data ...