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 form…

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

Date formatting

Ask for Help

Jeff_Hager January 19, 2020, 5:35pm 8

Check out the Dates Example sheet here:

Cerate an appointment module

Choice / Date component - Need your help

Topic		Replies	Views
📆 Date/time formats General	82	7466	December 29, 2020
Date format Feature Requests	14	2776	January 14, 2020
Formatting Array date & time from Google Sheets Ask for Help	9	5537	January 17, 2024
Date format help Ask for Help	3	820	August 31, 2020
Is there anyway to change the Date & Time format of logins page? Ask for Help	5	332	March 28, 2023

Date formatting

Related topics