9 Replies Latest reply: May 2, 2016 8:51 AM by Ruben Marin RSS

    Load Script change by date

    Frank Mogavero

      Greetings,

       

      I am trying to load two different sets of data depending on the date. From the first business day of the month to some date around the 14th of the month, one set of data is used. This is preliminary data.  From some date around the 14th of the month to the last business day of the month, different data is used.  This is Final data.  I would put an update date into a SQL table when the data is updated mid month.  That way I can check to see if the final data has been updated.

       

      Is there a way to read the update date and then load the proper set of data?

       

      I am thinking "IF Month(today) is greater than Month(update date) then load the final data, else load the preliminary data.

       

      Thanks,

      Frank