Customize Field type from Text to ISO Date & Time

Ask the community
#1

Hi, I’ve imported a field from excel containing dates in the formate 2020-03-14 22:38:39 UTC

I’m trying to customize the field into Date in order for me to Group the dates by Year and Month.
But if I run the standard operation the field returns empty with no data in it.

Thank you in advance.

Grant

#2

I’m not sure what you mean by “run the standard operation”.

After you imported the data from Excel, did you customize the field type to a date field?

Once the field type is set to date, you can use a formula field to identify the year and month for grouping. You can experiment with the YEAR, MONTH, and DATETIME_FORMAT functions, which are documented in the formula field reference.

#3

Hi @kuovonne

Thank you for the reply,
Yes I tried to customize the field type to a date field but then all my data is erased from that field.

Would I use DATETIME_PARSE(date, [‘input format’], [‘locale’]) ?

#4

Yes, if Airtable is unable to automatically convert the date string to a date type, create a new formula field using DATETIME_PARSE. Then after the formula calculates the date, convert the formula field to a date field.

#5

Thank you I actual managed to use DATETIME_FORMAT successfully for this task. And then convert the field to date type.

Your help is much appreciated @kuovonne

#6

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