Convert Google Analytics Hour of Day

[Anna_Allingham]

I have imported our Google Analytics data through AirFlow and would like to convert the Hour of Day to the correct format. The way GA has it formatted is “2021070100”, which is 7/1/2021 at 12:00 AM. Is there a formula I can use to get the desired outcome? Thanks!

[Cameron_Kaiser · Accepted solution]

Formula: DATETIME_PARSE({Time Field}, “YYYYMMDDHH”)
The way it works is that you’re telling the parser your data is in the format “year month day hour”. Be mindful of the repeating letters, because they indicate the length of each unit. For example, the YYMDHH format of your date would be 217100 (same date, different format).

A list of Airtable’s date unit shorthands can be found here: Supported format specifiers for DATETIME_FORMAT – Airtable Support

[Anna_Allingham]

Great, thank you so much!