Convert Epoch Date/Time to Standard Date/Time ⌚

Danny Roden
Danny Roden Administrator
edited January 29 in Functions library

Convert Epoch Date/Time to Standard Date/Time ⌚

This function was inspired by this post and created to support any users exploring use of the Data Studio API as a source to generate meainginful MI (e.g. reporting on sessions/events/activties/jobs/users and more) as Data Studio's publishes times in the epochtime format (i.e. how many milliseconds since 1st Jan 1970).

As the name suggests this function simply converts this value into a standard date/time format for easier onward processing:


This function is compatible with all instances of Data Studio from v2.9.6 onwards.