Calworkseconds function

rameshm468 over 5 years ago

Hi All,

I am getting below error

Expression evaluation error at function 'calworkseconds': Error evaluating function 'calworkseconds' : Null argument not allowed

kindly anyone help on this

Thanks,

Discussion posts and replies are publicly visible

Parents

0 Mike Schmitt
Certified Lead Developer
over 5 years ago

Where is the function "calworkseconds" from? I don't have such a function in any of the environments I have access to..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Mike Schmitt
Certified Lead Developer
over 5 years ago

Where is the function "calworkseconds" from? I don't have such a function in any of the environments I have access to..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 rameshm468 over 5 years ago in reply to Mike Schmitt

Hi Mike,

Am using 16.1 version nd below is properties for the function

calworkseconds(starting_datetime, ending_datetime, calendar_name)
Returns the number of workseconds between two dates, excluding any non-working times in the calendar.
Returns: Number (Integer)
starting_datetime (Date and Time): The starting date time.
ending_datetime (Date and Time): The ending date time.

calendar_name (Text): The calendar to use to obtain working times

Thanks,
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel