6 Replies Latest reply on Feb 14, 2017 9:08 AM by Michael Szymanski

    How to account for null values in unix timestamp for DateAdd function?

    Michael Szymanski

      Hello,

       

      I am using this DateAdd function to convert the UNIX time in milliseconds to a normal date.

       

      DATEADD('second', DIV([Date Available], 1000), #1970-01-01#)

       

      However, It throws an error when the value is null.  How do I change the code to account for NULL values?

       

      Thank you.

       

      Michael