Help

Convert date to text in new field

Topic Labels: Formulas
4490 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Ryo_Kobiyama
4 - Data Explorer
4 - Data Explorer

Hi there,
How do I convert date to text in a new field by formula?
I have one date filed(2021/5/16 9:00) and need to convert it to text data.
Does anyone have a solution?

2 Replies 2
Adam_Minich
Airtable Employee
Airtable Employee

Hi @Ryo_Kobiyama,

Adam from Airtable here.

I believe you could use the DATESTR() function to get that result. You can find more info at this link: Formula field reference – Airtable Support

Let me know if that helps~~

Welcome to the Airtable community.
I recommend the DATETIME_FORMAT() function, with SET_TIMEZONE().
The exact formula would depend on your timezone and the format of the string you want. This should get you started.

DATETIME_FORMAT(
  SET_TIMEZONE({date field name}, 'Australia/Sydney'), 
  'YYYY/M/D h:mm'
)

You can use the formula field reference, list of format specifies, and list of timezones to further adjust the formula to match what you want.