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.

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’]) ?

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.

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