1

I have a simple formula date field which I want to return a BLANK DATE (not a NULL) if the criteria is false. I tried many syntax, but all failed

1

There is nothing called a blank date to my knowledge.

It would be either one of the below two

I) Any date

II) Null

You cannot assign any other value apart from these two!

| improve this answer | |
  • Null returns Error? can you explain what are you trying to achieve? – Prag R K Jul 21 '17 at 1:03
  • I created a temp blank date and pointed to that field in formula. Now all good now – Jay Weera Jul 21 '17 at 22:10
3

There is no blank date, rather you can get an empty field value. You can use this to have an empty(no date value) field:

IF( 
 Condition, 
 NOW(), 
 NULL 
)
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.