Date formatting

Hey spreadsheet masters.

I am using the app:logins first entry per user as a “registration date”. I’ve created a duplicate spreadsheet where I added a column that was meant to have the formatted date but for some reason I am not being able to format it. I’ve tried formatting it with the sheets formatting and with text(Datecolum, “dd/mm/yyyy”) formula.

Does anyone know what I can do?

Thanks in advanced

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

1 Like

Thank you so much @Jeff_Hager. Worked like a charm.

1 Like