5 Replies Latest reply on Sep 9, 2009 3:21 PM by Invectus

    Solved! Event Status field: help needed in scrpt steps

    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