
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 11, 2020 02:08 PM
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 11, 2020 02:13 PM
It’s missing an opening parenthesis, and it’s got an an unparsed date string.
You need to use DATETIME_PARSE()
to parse the string into a DateTime object to compare with your Date field.
Also, you may want to use the IS_AFTER()
date comparison function.
I think this should be your equivalent formula:
IF(
IS_AFTER(
{purchase-date},
DATETIME_PARSE("02/01/2020", 'MM/DD/YYYY')
),
"Yes",
"No"
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 11, 2020 02:13 PM
It’s missing an opening parenthesis, and it’s got an an unparsed date string.
You need to use DATETIME_PARSE()
to parse the string into a DateTime object to compare with your Date field.
Also, you may want to use the IS_AFTER()
date comparison function.
I think this should be your equivalent formula:
IF(
IS_AFTER(
{purchase-date},
DATETIME_PARSE("02/01/2020", 'MM/DD/YYYY')
),
"Yes",
"No"
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 11, 2020 02:24 PM
Thanks you very much

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 11, 2020 02:25 PM
You’re welcome :slightly_smiling_face:
