Oct 25, 2024 12:04 AM
Hi everyone,
I have been struggling with comparing a date of when a record has been created to a date I am manually inputing into the formula. So basically I am trying to use the IS_AFTER function but have tried so many things and just everything is either coming up with error or false to all fields even though i know some of them are after the date i am specifying.
I am trying to get all records that are true to being created after the 21/10/2024 and feed them into a make.com automation using this field or formula.
This is the formula I have been using but all the fields are showing up as 0 (false) when there are definitely some records created after the 21/10/2024. I had to use the date format with the date parse as it was automatically formatting the date in US format even though I have specified the format?
Oct 25, 2024 03:01 AM
Hello,
You do not need to change the date format within the formula, all you need to do is to input the compared date '21/10/2024' as '10/21/2024':
You should get the following result:
Regards,
Pascal
Oct 25, 2024 04:06 PM - edited Oct 25, 2024 04:07 PM
Hey Pascal,
I thought I was over complicating the hell out of it.
so just to confirm when using formulas with dates and times if you write a formula manually it has to be in US format for it to work?
Oct 25, 2024 11:43 PM
@Pascal_Gallais- Hmm, I think there's some sort sort of interaction between the format of the Date field and the format we key in to the formula? The formula didn't give provide the expected results, and I think it's because my Date field is set to "Friendly"
What do you think of us doing a single DATETIME_PARSE() at the end?
IS_AFTER(
Date,
DATETIME_PARSE(
"21/10/2024",
"DD/MM/YYYY"
)
)
Oct 26, 2024 06:32 PM - edited Oct 26, 2024 06:42 PM
Hi,
You can Use ISO format in formula to avoid mixing day and month.
It's the format with constant length (10 chars without time, '2024-10-27') and it can be sorted as string in correct order.
Anyway, it's better to use special date functions, than usual math operators. I mean, using 1st foirmula is OK. Using 2nd - OK, but check if possible, especially. 2024-09-21