Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Convert date to text in new field

Topic Labels: Formulas
1978 2
Showing results for 
Search instead for 
Did you mean: 

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

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.

  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.