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



      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.