If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Simple Event Studio expression help needed

Started by strig1, 25 Jul 2014 08:52:14 AM

Previous topic - Next topic

strig1

I'm new to event studio and i'm trying to run a basic event trigger. I am using a primavera package and my trigger is "Email __bob___ when a task is not started within 4 days of scheduled start date.

Expression as of now: [Act Start Date] is null and [Target + 4] > [Target Start Date]
-where [target + 4] is a calculation: [Target Start Date ]+ 4

I need advice as to why this isn't working, am i missing a component? I feel like the calculation is what is the problem. The picture provides the actual information that the query has. Thanks!


Raghuvir

Quote from: strig1 on 25 Jul 2014 08:52:14 AM
I'm new to event studio and i'm trying to run a basic event trigger. I am using a primavera package and my trigger is "Email __bob___ when a task is not started within 4 days of scheduled start date.

Expression as of now: [Act Start Date] is null and [Target + 4] > [Target Start Date]
-where [target + 4] is a calculation: [Target Start Date ]+ 4

I need advice as to why this isn't working, am i missing a component? I feel like the calculation is what is the problem. The picture provides the actual information that the query has. Thanks!



hi Strig,

Have you scheduled your event to run daily ?

Regards

MFGF

Quote from: strig1 on 25 Jul 2014 08:52:14 AM
I'm new to event studio and i'm trying to run a basic event trigger. I am using a primavera package and my trigger is "Email __bob___ when a task is not started within 4 days of scheduled start date.

Expression as of now: [Act Start Date] is null and [Target + 4] > [Target Start Date]
-where [target + 4] is a calculation: [Target Start Date ]+ 4

I need advice as to why this isn't working, am i missing a component? I feel like the calculation is what is the problem. The picture provides the actual information that the query has. Thanks!



I think your issue is with the calculation - trying to add an integer (4) to a date. Try using the _add_days() function to add four days to your date.

Cheers!

MF.


Sent from my iPad using Tapatalk HD
Meep!