How do I convert this 2021-07-14T00:00:00.000Z date string value into the YYYY-MM-DD format. | Community
Skip to main content
M
MarySt3
New Participant
July 17, 2023
Solved

How do I convert this 2021-07-14T00:00:00.000Z date string value into the YYYY-MM-DD format.

  • July 17, 2023
  • 1 reply
  • 2678 views

I am entering the following in 'Date Format Function' FormatDate("023-07-17T13:00:00.000Z"; "MM/DD/YYYY") in my filter.

 

The errors I am getting include

  • The bundle did not pass through the filter because of an error. Failed to evaluate filter '0-2': Function 'formatDate' finished with error! '023-07-17T13:00:00.000Z' is not a valid date.
  • 12:21 PM
    Cannot process data because of the error. The reason is: Failed to evaluate filter '0-2': Function 'formatDate' finished with error! '023-07-17T13:00:00.000Z' is not a valid date.
  • 12:21 PM
    The scenario was finalized.
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by _Manish_Singh

The year portion needs correction. It should be "2023" instead of "023" according to the ISO format. 

The corrected date format is: FormatDate("2023-07-17T13:00:00.000Z"; "MM/DD/YYYY").

1 reply

_Manish_Singh
_Manish_SinghAccepted solution
New Participant
July 17, 2023

The year portion needs correction. It should be "2023" instead of "023" according to the ISO format. 

The corrected date format is: FormatDate("2023-07-17T13:00:00.000Z"; "MM/DD/YYYY").

    Terms & ConditionsAccessibility statement

    Loading footer...