Hi,
I work with a database with multiple timestamp for each record. My calculations depends on them. There are many people pulling data, most of which are not familiar with databases at all.
For that reason I do not want to change the format that I picked: mm/dd/yyyy hh:mm. That avoids different formats that could impede calculations.
However, sometimes the timestamp is not available. Is there any way of adding a dropdown including: "Not recorded" without getting a error message?
Any help is welcomed.
Thank you!
A timestamp field will only take a timestamp-formatted piece of text. So I don't think there's a way to enter data into that field.
You could add another calc field with the calc: If (IsEmpty (YourTSField) ; "Not recorded" ; YourTSField) then you could do your calculations of this calc field. But how would you calculate off a field that says "Not Recorded"?