Date field does not remain empty
I have a few date fields that don't remain empty after I clear them.
Mac app 3.12.4
Only certain records show the behavior.
I clear the date and exit the database. When I return to the database the date fields have the date:
Jan 1, 1970
In date field properties I have - Required: no, Show in calendar: no. Other combinations don't seem to affect the behavior.
Things I've tried:
clear the field in a table view with a double-click
use the clear function in the calendar popup
use a button script to clear the field with a null value
Has anyone seen this behavior?
Thanks
19 replies
-
Wow, I thought this would have been fixed by now. Here is a post from a year ago with the same issue.
I tried it out in 3.12.2 and was only able to reproduce it only on local stored DB. iCloud DBs do not have this problem.
-
Hello,
I thing you have to reach out to the support team of the Mac app. They can provide insights into whether this is a known issue, offer any workarounds, or escalate the matter for further investigation.
-
I have exactly the same problem, and cannot find any places with a solution for it - and by the way mine is in icloud
-
Just for the record - I'm totally web based and I cannot get this error to occur.
I presume you have tried Date:= " " too.
and assume you don't have anything in the table triggers ( on new and on update)
what happens if your force the Date to all zeros. Date := 00/00/0000 ? Does that hold up or do you still still leap to 1970?. When I try this and return to the record I show an empty field (i know its not really empty but .....but better than showing a spurious date
Content aside
- 2 mths agoLast active
- 19Replies
- 144Views
-
5
Following