9 Replies Latest reply on Jul 1, 2016 12:42 PM by TSGal

    GetAsNumber of Empty Timestamp field incorrect result if math applied


      1. Create a TimeStamp Field called MyTimeStamp

      2. Create an unstored calculation field called MyGetAsNumber

      result text - always evaluate of the following formula:


      GetAsNumber ( GetAsNumerOfTimeStamp::MyTimeStamp ) + 0


      the expected result is: "0"


      actual result is: 1/1/0001 00:00




      can also be replicated with simple setup:


      create a timestamp field

      in data viewer display:

      GetAsNumber ( GetAsNumerOfTimeStamp::MyTimeStamp ) + 0


      and also the result is on empty MyTimeStamp not the expected 0

      instead it shows: