Problem with the filter and the date

Questions & Answers
#1

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

CleanShot 2022-05-17 at 09.45.25@2x
CleanShot 2022-05-17 at 09.45.25@2x2222Ă—870 173 KB

CleanShot 2022-05-17 at 09.45.47@2x
CleanShot 2022-05-17 at 09.45.47@2x2188Ă—760 162 KB

#2

@Thomas

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

2 Likes
#3

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