GetAsNumber of Empty Timestamp field incorrect result if math applied

Discussion created by FileKraft on May 16, 2016
Latest reply on Jul 1, 2016 by TSGal

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: