Convert date to text in new field

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.

NM, found it.