Forum Discussion

Shawnaby's avatar
Shawnaby
New Contributor
4 years ago

My Filter Expression for Dates is not working

Hello All, I have a date field in input and I’m trying to apply a filter I want to filter only for the date type field: ZCC04 Proc. Date where it is before today’s date minus 11 days. I’ve tr...
bojanvelevski's avatar
bojanvelevski
Valued Contributor
4 years ago

Hey @Shawnaby,

I believe that this is happening because the date is not parsed at all. Can you show us the format of the incoming date?

  • darshthakkar's avatar
    darshthakkar
    Valued Contributor
    4 years ago

    Agreed with @bojanvelevski’s point.
    The data type might be different for both the dates for which Date.parse didn’t work for you.

    I’ve tested the same solution and it was working for me, please refer to this for more details:

    • Shawnaby's avatar
      Shawnaby
      New Contributor
      4 years ago

      Yes I had to parse the date. I thought it was already in date format, so I thought I didn’t need to specify the convention after the field ($xxx, yyyy-MM-DD)…

      • darshthakkar's avatar
        darshthakkar
        Valued Contributor
        4 years ago

        Great, so is it safe to assume that the issue has been resolved?