Exporting the Audit Log

[MargretteBoyer]

I'm currently exporting the audit log and noticed that the date and time format in the exported file differs from how it's displayed within the instance. I've attached a screenshot showing the comparison between the two formats. I've tried a couple of times in excel using Text to Date and custom formatting, but it's still not showing correctly. Not sure what I'm doing wrong.

Is there a way to adjust the exported data so the date and time appear consistent with the instance view? I’d appreciate any guidance you can share.
Thanks so much!

[skyehansen]

I think Workfront stores a lot of its dates in universal time, so this is likely to be about as good as you're going to get and will have to manually convert after you get it into the spreadsheet.

[MargretteBoyer · Accepted solution]

Thanks, Skye

I tried so many different methods Text to Columns, various formulas you name it. But I kept getting that dreaded #VALUE! error. 

After some trial and error, I finally cracked it and OMG... it's a total life saver! 

If anyone else is running into issues after exporting the audit log from Workfront into Excel, I’ll gladly share how I got it working. It might save you a ton of frustration!

VBA Macro for Your Format  - This version extracts the date and time from the UTC string and converts it to EDT:

Example Conversion

• Original (UTC): Mon Oct 06 2025 19:39:50 GMT+0000
• Converted (EDT): 10/6/2025, 3:39:50 PM

How to Use It

1. Press Alt + F11 → Insert → Module → paste the Vba code. (Attached)
2. Go back to Excel.
3. Select the cells with the UTC timestamps.
4. Press Alt + F8 → choose ConvertWorkfrontTimestamps_EDT → click Run.