google analytics datetime to proper format

[Roberto456]

Helllo everyone.

Does anyone know a way to convert GA datetime format to a proper format?

I believe their format is: YYYY/MM/DD/HH/MM

[Anonymous · Accepted solution]

@Roberto456 
Create the following column:

new date/time = 
Var date_ = DATE(LEFT([GA datetime],4),RIGHT(LEFT([GA datetime],6),2),RIGHT(LEFT([GA datetime],8),2))
Var time_ = TIME(LEFT(RIGHT([GA datetime],4),2),RIGHT([GA datetime],2),00)
Return date_+ time_

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.