Forum Discussion
Custom column with date
Hello, I have a table with a field that populated with the date '31-12-9999' when it's actualty empyt. There's also an integer field with the value -99999999 (or de the date for exampl 20180917,...
I've found the BLANK() function and that works.
Sorry, I'm a newbie so still searching and learning.
Try 0 instead of "0".
That will prevent the error. The error is caused because the calculated column can't have values that are text or datetime (in the same column)