2 Replies Latest reply: Mar 14, 2017 7:27 PM by Ivan Drago RSS

    Run script if condition met.

    Ivan Drago

      Hi,

       

      I want to create a QVD if the current time is between the hours of 08:00 AM and 10:00 AM, if it does not meet this condition I want it to Exit the Script.

       

      I've tried to do the following Script IF Statement but does not seem to work, any ideas?

       

       

       

      LET vHour = Hour(Now());

       

      If vHour >= 8 And  vHour <= 10 Then

       

      TableA:

      LOAD *;

      SQL

      SELECT *

      From TableA;

       

      ELSE EXIT SCRIPT;

       

      Thanks