JimHarrison
16 days agoQrew Champion
Audi Log TIME (ISO-8601) Conversion
Wondering if anyone has done the work to convert the Quickbase Audit Log Timestamp to local time?
I export the logs via CSV and then am working towards a process to convert the "2024-10-28T15:53:25.956Z" timestamp to PST. I'm seeing it as a multistep process involving text to columns and then math.
If you have a simpler solution, I would appreciate hearing how its done.
Thanks,
ChatGPT to the rescue.
=TIMEVALUE(MID(A2,12,8)) - TIME(7,0,0)=DATEVALUE(LEFT(A2,10))