Question
Has anyone used TimeDifferenceFirstBusinessDay() Function ?
Have anyone used TimeDifferenceFirstBusinessDay() Function? I am having trouble with the aCalendar parameter.
It says that if aCalendar is null - it should use server's default calendar and local time zone, but it is failing validation if I leave it null.
And what should one give for the calendarObject? should I have to provide the instances of Data-Admin-Calendar ?
Description:
Returns the first business day after the specified DateTime, using the specified calendar.
Usage:
Returns the first business day after the specified date, using "business day" logic (assumes US business day rules (Saturday/Sunday closed), ignores possibility of holidays (constant 5 day weeks)).
Parameter:
aCalendar: calendar to be used for computation, if null, uses the server's default calendar and local time zone
strStart: base date/time, if null or zero length, uses the current date and time
Example:
TimeDifference(calendarObject, "20090127T224645.845 GMT") = "Thu 2009/01/29 23:47:46 GMT+00:00"
Message was edited by: Lochan to add Category
Are you getting validation error when you use this function via expression builder? If so, try using this function through a java step, then you would be able to pass null parameters.
aCalendar parameter is of java.util.Calendar type. So you need to pass Java Calendar object and not Data-Admin-Calendar.
If your intention is to get business day after a certain day, then nextBusinessDay function might be useful one for which you can pass Data-Admin-Calendar instance name.
Hope this helps you!
Murali...