Problem with the filter and the date


I use make to automate my Notion space.

In a scenario, I want to compare the date.end of a database item with the date.end or I change the time to 14:00.
My problem is that basically the time value of date.end is 12:00, and according to the make filter 12:00 > 14:00, so my filter is incorrect.
I am attaching photos to show you this problem.

Is it a bad practice on my part?
Could you help me?

Thank you very much for your answer.




Two possible issues I see are:

  1. The “-04:00” at the end of the “1. End” value means that the date is a string type not a “real” datetime type.
    Convert to a date type using parseDate() and possibly substring() functions.

  2. To compare datetime values you must use Datetime operators, e.g., “Earlier than” and NOT numeric operators.

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Creating monday subitems using Make/Integromat The Monday Man Way
Contact me directly here: Contact – The Monday Man


Hi Jim,

Thank you very much for your answer. It helped me a lot.

Indeed, the start and end date on the Notion side is seen as a string on the Make side. So I had to reformat it as I wanted with a Substring and then put it back in Date.

Thanks again.