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.
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:
@Jeff_Hager I have a choice component that display date as “Sun 16/01/2020” and need to change it back from text to date value in the format of “dd/mm/yyyy”. I have tried Seting date from within google sheets, Tried To_date, Datevalue etc … but in vain.
Thanks @George_B I am trying to add a range of minutes from 10:00 am to 11:30 pm to a singular date and it’s not working.
I am trying to add a 30-minute range to start of business hour 10:00 am till closing time at 11:30 pm to a singular date and it’s working. To elaborate Mon 20/01/2020 need to add to it 30-minute time interval till it reached 11:30 pm and displayed vertically in this format
Mon 20/01/2020 10:30 am
Mon 20/01/2020 11:00 am
Mon 20/01/2020 11:30 am ….etc
I’ve used this formula but is not working as it should, Thanks for the help