Hi community 
,
I’m trying to create a filter to check if a given date falls within a specific month.
I’m using the following expression in the filter:
make
Copiar código
formatDate(1.columnV; "MM")
Then I’m comparing it to 05 using the “Equal to” operator (to catch May dates).
The date in the input is clearly something like 2025-05-31, so I expected it to pass the filter, but it doesn’t.
Am I doing something wrong here? Could it be that the date field is not in a proper date format and I need to use parseDate() first?
Any help, insight or workaround would be greatly appreciated 
1 Like
Hi @jose2023,
I’m sorry I don’t have a clear answer but usually before I set my logic in the condition field, I’ll use the “Set Variable” step to see what the logic produces. Hopefully this will give you more insight on what the output of the formatting is.
-@Trainward_Consulting
Hey Jose,
Firstly remove the double quotes around MM, they are not needed and are getting added to the output. So it will be “05” which wont match 05.
Then, you can hover over the variable to see if its date type or string. If its string, you will need parseDate first to change it.
Hello! @Trainward_Consulting
I have never tried this before, but I will try it. Thank you.
1 Like
