Formulas can be set up in the Detail section for due dates and timers.
Example UC(Japan);BD(1);OT(00)
For the detail UC, Refer to 6.22.6 Assigning Business Calendars to Due Dates or Timers
Time Codes
Code | Meaning | Example |
---|---|---|
AT | Sets the absolute time of the day. | AT(16:30:00): 4:30pm on that day. |
CT | Sets the business time relative to the closing time of the day. Allowed values: 00 or negative hours. Typically you will use negative hours with closing time in order to calculate a relative time before closing time. | CT(00): Closing time. CT(-02:00:00): 2 hrs before the closing time. |
OT | Sets the business time relative to the opening time of the day. Allowed values: 00 or positive hours. | OT(00): At the opening time. OT(02:00:00): 2 hrs after the opening time. |
BT | Sets the business time relative to the current time of the day. | BT(04:30:00): After 4 & 1/2 business hours from the current time. BT(-02:00): 2 business hours earlier. BT(00): Use this to search forward to the next business time, without changing the time if the current time is not a business time. You may need this if different business days have different hours. BT(-00): Use this to search backward to the last previous business time. Has no effect if the current time is already during business time. |
Day Codes
Code | Meaning | Example |
---|---|---|
BD | Sets a business day. | BD(4): Four business days from today. BD(0): Same day if it is a business day, else the next day. BD(-0): Same day if it is a business day, else the previous day. |
RD | Sets a relative day from the current day. | RD(7): After one week. RD(-1): One day earlier. |
WD | Sets a day of the week. Allowed values: 1 to 7. | WD(1): Sunday of that week. WD(7): Saturday of that week. WD(8): Sunday of next week |
WN | Sets the next weekday after today. Allowed values: 1 to 7. | WN(1): The next Sunday after today. WN(7): The next Saturday after today. |
RM | Sets a relative month in the future. If the month does not have enough days to be the same day, the day will be the last day of the month. | RM(3): After 3 months |
DM | Sets an exact day of the month. Allowed values: Any number except 0. | DM(1): The first day of the month. DM(-1): The last day of the month. |
BM | Sets an exact business day of the month. Allowed values: Any number except 0. | BM(1): The first business day of the month. BM(-1): The last business day of the month. |
DY | Sets a day of the year. Allowed values: Any number except 0. | DY(1): The first day of the year. DY(-1): The last day of the year. |
BY | Sets a business day of the year. Allowed values: Any number except 0. | BY(1): The first business day of the year. BY(-1): The last business day of the year. |