Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 13, 2024 04:22 AM
I would like to create an automation that reminds me by email 1 month before a date from a formula field. Unfortunately I can't change the value of a formula field to dynamic or say the date is within 1 month like I can with a real date field. that doesn't work.
Solved! Go to Solution.
Sep 13, 2024 11:28 PM
Hello,
The problem comes from the fact that your formulas "Datum in 1 Monat" and "Berechnung" are not considered as date type fields, meaning that you can not pass them to the "DATETIME_DIFF" function.
I guess that these two fields are obtained with a "DATETIME_FORMAT" function to get the format "MM.YYYY". If so, you could then use the original dates in the "DATETIME_DIFF" function.
Regards,
Pascal
Sep 16, 2024 04:03 AM
Hello,
The "DATETIME_DIFF" function is the one that you used in the formula for your field "erinnerung".
As I said in my previous answer, it can not work as you defined it because you must pass two date type fields to this function, reason why I suggest that you pass as parameters the two dates that you used to compute your fields "Berechnung" and "Datum in monat".
Regards,
Pascal
Sep 13, 2024 05:52 AM
Hello,
You may try something like that:
"Date 1" is a formula retruning a date
"Date one month before" is a formula to get the reminder date, one month before "Date 1":
Sep 13, 2024 09:31 AM
Sep 13, 2024 11:28 PM
Hello,
The problem comes from the fact that your formulas "Datum in 1 Monat" and "Berechnung" are not considered as date type fields, meaning that you can not pass them to the "DATETIME_DIFF" function.
I guess that these two fields are obtained with a "DATETIME_FORMAT" function to get the format "MM.YYYY". If so, you could then use the original dates in the "DATETIME_DIFF" function.
Regards,
Pascal
Sep 16, 2024 01:18 AM
yes, that's exactly what is created with DATETIME_ FORMAT. what exactly do you mean by the DATETIME_DIFF where should I use that?
Sep 16, 2024 04:03 AM
Hello,
The "DATETIME_DIFF" function is the one that you used in the formula for your field "erinnerung".
As I said in my previous answer, it can not work as you defined it because you must pass two date type fields to this function, reason why I suggest that you pass as parameters the two dates that you used to compute your fields "Berechnung" and "Datum in monat".
Regards,
Pascal