Filtering by date on the Data Store is not returning any results

I’m struggling with the filter in the ‘Data Store’ [Search Records] module.
The date seems to be set correctly at first glance, but it doesn’t return any values from the Data Store, even though it should.
If I remove the date-related filter for ‘earlier than or equal’, leaving only the ‘less than or equal’ condition, it works.
However, if I use only the ‘earlier than or equal’ condition, it doesn’t work.

Tks!

I would really appreciate any help or clues about what might be going wrong.




Hi @rwiz

formateDate function will return text. If you are using date filter then the values should be in date format to compare. You can use parseDate function instead to solve the issue.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

3 Likes

Hi!

Nice one, it worked perfectly!

Thank you!

1 Like

Hi @rwiz

Glad to know that your issue is resolved now.