Date stamp

[Jeff_Hager]

The app:logins sheet contains a timestamp whenever a user signs in to a new device or is required to enter a new pin. Unfortunately the date is in a string format instead of date, so it will need to be converted:

Date formatting

I don’t think Glide is saving it as a true date value. It’s appears to just be text. Try this formula. It strips out the T and Z, then converts it to a date value which can be reformatted using TEXT: =TEXT(DATEVALUE(MID(A2:A,1,10)) + TIMEVALUE(MID(A2:A,12,8)), "DD/MM/YYYY")