6 Replies Latest reply: Jul 22, 2013 4:12 PM by Andrea Reyes RSS

    Calculation during load from resident table data in memory

      Here is the situation.... I am about to load data from a resident table, with code like....

       

       

      Table:

      LOAD

      [Arrival DateTime],

      [Screen DateTime],

      [Depart DateTime]

       

      RESIDENT Temp_ET;

       

       

      I want to do a date difference in minutes between [Arrival DateTime] and [Screen DateTime] as well during the load...BUT if one of them is null then I want to return null obviously. Also, if for some reason in the data, the [Screen DateTime] is earlier than the [Arrival DateTime], then I also want to return null instead of a negative value. How can I add this calculation into the load?