Forum Discussion

JimHarrison's avatar
JimHarrison
Qrew Champion
16 days ago

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))



  • ChatGPT to the rescue.
    =TIMEVALUE(MID(A2,12,8)) - TIME(7,0,0)

    =DATEVALUE(LEFT(A2,10))



  • Jim,

    There is no time zones in the date/time function of Excel.  The math gets very tricky when the calculation will take you back across midnight.

    1 AM GMT on the 5th is 6PM on the 4th assuming there is no Daylight Saving Time issues.   

    I would import this back in to Quickbase and have a Pipeline update a new field with a conversion to the timezone that you want.