Skip to Content
0
Former Member
Feb 20, 2011 at 03:56 AM

Incrementing Date field in Variable based on a specific calendar

52 Views

Hello All,

I am currently setting up a schedule that includes Mass activities. I am running into a problem when i want a particular date field an activity to increment by one day based on a specific calendar i.e. Factory calendar (M-F open).

EX)

The due date field for on any given day the mass activity runs should be system date plus 2 business days.

While the posting date field on the same transaction should increment by 2 day.

Result would be:

On System date = 02/17/11

Due Date Field = 02/21/11

Posting Date = 02/19/11

I am currently using expression similiar to this: =Time.expression(Time.now('GMT'), 'add 2 days') but cannot find documentation how to include calendars in this as you would with =Time.isTimeWindowOpen(Time.now('GMT'), 'Factory Calendar').

Can someone please point me in right direction?

Thanks

Dan