Forum Discussion
IF formula for Custom Column error
My goal is to replace empty date values in a table to a custom date value (31/12/9999 e.g.) by adding a new column where I use an IF function. The new column should be composed out of '31/12/9999...
Anonymous , Try like
IF ( ISBLANK ([Date Finished]) , date(9999,12,31), [Date Finished])
Dear, I still receive the same error. If something wrong with my settings?