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
Is there anyway to change the Date & Time format of logins page? Ask for Help	5	333	March 28, 2023
Change Time Zone Feature Requests	1	580	April 24, 2020
Date format Feature Requests	14	2792	January 14, 2020
Data written to spreadsheet from app as Text format not Time format Ask for Help	21	1077	January 10, 2023
Incorrect Date Format Ask for Help	6	274	December 1, 2021

Date formatting

Related topics