Running TI process on specific date every month

Post Reply
late.vaibhav
Posts: 25
Joined: Mon Dec 09, 2013 1:00 pm
OLAP Product: tm1
Version: 9.5.2, 10.2.2
Excel Version: 2007 2010
Location: India
Contact:

Running TI process on specific date every month

Post by late.vaibhav »

Hi;
Is it possible to schedule TI process to run any specific date of every month.
Now I am doing this by setting my start date and time on desired date and Chore frequency as 30 days, but this get failed when the day are 31 OR 28.

Regards;
Vaibhav
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Running TI process on specific date every month

Post by rmackenzie »

This is straightforward with use of a couple of the standard time and date functions:

Code: Select all

sToday = TODAY ( 1 );
nDay = DAY ( sToday );
IF ( nDay = 24 );
  # ExecuteProcess... or your logic goes here
ELSE;
  ChoreQuit;
ENDIF;
Robin Mackenzie
Post Reply