Expand my Community achievements bar.

Fix the Date on .csv downloads in Analytics

Avatar

Level 1

2/7/24

Description - When downloading an Analytics Project, the date in the .csv file comes in a UNIX format. This requires a formula in excel to convert to a readable date. 

Why is this feature important to you - I have users that are not technical and could benefit from a csv export on a preset Project. But they are unable to use the project dashboard because of this bug.

How would you like the feature to work - Have a regular date field

Current Behaviour - The date appears in UNIX format (which is not useful) for example Monday, July 3, 2023 will show as "1688356800000". This is not helpful or meaningful for any user. In order to convert the date to a normal setting I have to use a formula "=(CELL/86400000)+DATE(1970,1,1)" to convert the date. 

1 Comment