I have the following problem and my solution doesn’t work Could you share your advice, please?
I have an automation that delivers a date field in the following format YYYY-MM-DD. However, this is not useful for EU users so I tried to change the format by creating a new formula field that converts the date information to the format I want. The problem is that in Gmail automation that sends the mail with information, the new field (with formula) is blank…
Welcome to the community, @Dimitris_Goudis! Could you please share the formula that you’re using to change the date format, and also share screenshots of your automation setup? This will make it a lot easier to figure out what’s happening.
The problem is in the field “Ημερομηνία Παράδοσης”. This field is a lookup field that parses a date from another table. The parsed field is a formula field with the following function that converts the date into the willing format.
Sorry for the delayed reply. If I understand you correctly, you’re saying that inserting the formula field into the email sometimes doesn’t work, resulting in a blank space where the date is supposed to be. Is that correct? That’s what I gather from your original question. However, in your latest reply you said:
The reason that you’re getting that format by directly inserting the date is because the formatting that you see in the field is only for display purposes. To display that date anywhere else, you’ll typically use the DATETIME_FORMAT() function. Another function that might be useful is the SET_LOCALE() function, which is used together with DATETIME_FORMAT() to create a formatted date with specific locale (language) options. While the function that you wrote will also work, I suggest checking out the details in the documentation about both of these functions: