FileKraft

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:

Outcomes