I have a field which look at a date field and depending if it exists will write "Scheduled on {Scheduled}
The formula is IF({Scheduled}>TODAY(),"Scheduled on "&{Scheduled}, “Not scheduled”),
But it writes the info as “Scheduled on 2020-03014T00:00:00+00:00”
How do I format that text field as “Scheduled on 14-03-2020”
Thanks
+29Use the DATETIME_FORMAT formula around the date.
DATETIME_FORMAT({Scheduled}, 'DD-MM-YYYY')
The details are in the formula field reference.
Use the DATETIME_FORMAT formula around the date.
DATETIME_FORMAT({Scheduled}, 'DD-MM-YYYY')
The details are in the formula field reference.
That worked exactly. Thanks
+18Hi @Luke_Ellis - I’m guessing your first date field is text/single text line, looking at the formatting in the s/s. The reason you’re getting the result you see is that you are concatenating the result of two things:
DATETIME_FORMAT({BRA due}, 'DD-MM-YYYY')DATEADD({BRA due}, 3, 'months')This is what the & operator does - joins two things together, the result being a string.
In fact, you can just do the last part of this formula to get the date in the 3 months time:
DATEADD(Date, 3, 'months')
Notice that Airtable is interpreting your initial date string as a date, which is nice too.
JB
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.