Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Convert Google Analytics Hour of Day

Topic Labels: Formulas
Solved
Jump to Solution
383 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

1 Solution

Accepted Solutions

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

See Solution in Thread

2 Replies 2

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

Great, thank you so much!