Hello,
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.
Best,
Thomas
Two possible issues I see are:
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.
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.
Thomas
