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!
Page 1 / 1
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
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!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.