Hey @Vikas!
Welcome in!
So, one way to handle this is to create a formula field that formats your date value.
In this case, you’ll want to use the DATETIME_FORMAT
function.
You can use this format as an example:
DATETIME_FORMAT(
{Date Field},
'D-MMM-YYYY'
)
This will provide you a value in your desired format of: 22-Jul-2022
.
You’ll use that formula field to plug into your email/automation, instead of your original date/time field.
If I remember correctly, this formula will produce a string data type, rather than a date data type.
This means that Airtable will not transform the data when it goes through an automation, which is what was causing your original issue.
The DATETIME_FORMAT
function is my best friend.
If you want to play around with the formatting, here is a link to the formatting options.
Please let me know if something breaks, if I’m wrong, or if you have any additional questions!