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

    GetAsNumber of Empty Timestamp field incorrect result if math applied

    FileKraft

      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: