Salesforce: How to blank a date field in handlebar expression

Answered

Tom DeStefano

• July 27, 2022 12:56

Hello, I am trying to blank out a date field in SF.  OpenAir is passing a value of 0000-00-00.

I tried blanks.. null.  but the field won't update in SF.

{{#compare [Date field] "==" "0000-00-00"}}{{null}}{{else}}....

whats the correct format for null?

0

• Official comment

  

  SAMANTHULA SRI SATYA SANTOSH KUMAR

  • August 03, 2022 06:42

  Hi Tom,

  Try giving expression as {{#compare [date field] "===" "0000-00-00"}}{{else}}{{field}}{{/compare}}.

  No need to specify anything if we want to blank out a value.

  Thanks,

  Santosh

Please sign in to leave a comment.