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....





      [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?