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
Change Time Zone Feature Requests	1	582	April 24, 2020
Date format Feature Requests	14	2806	January 14, 2020
Date changed to different format after Edit Report a Bug	11	650	November 18, 2019
Is there anyway to change the Date & Time format of logins page? Ask for Help	5	335	March 28, 2023
Incorrect Date Format Ask for Help	6	281	December 1, 2021

Date formatting

Related topics