Convert date to text in new field

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?

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.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.