AnsweredAssumed Answered

Solved! Event Status field: help needed in scrpt steps

Question asked by Invectus on Sep 9, 2009
Latest reply on Sep 9, 2009 by Invectus

Title

Solved! Event Status field: help needed in scrpt steps

Post

Hi there,

 

I have a field named "status" that needs to display the status of an event.

 

1) If the current date and time are preceding the event start date and start time; the field should display this message : "Pending"

2) If the current date and time are between the event start date and start time, the field should display this message: "Work in progress"

3) If the event end date and end time are older than the current date and time, the field should should display this message: "Complete"

 

Here are mys script steps, can anyone please tell me what I'm doing worng 

 

Case (GetAsDate(JOBS::Date_service)<Get(CurrentDate) and GetAsDate(JOBS::Time_service_start)<Get(CurrentTime); JOBS::Status="Pending"; JOBS::Date_service=Get(CurrentDate) and JOBS::Time_service_start=Get(CurrentTime); JOBS::Status="Work in progress";JOBS::Date_service>Get(CurrentDate) and JOBS::Time_service_start>Get(CurrentTime); JOBS::Status="Complete" )

 

Sorry about the fuss,

Thanks a lot 

Outcomes