# Date formatting **URL:** \ **Category:** Ask for Help\ **Created:** [December 4, 2019, 1:11pm UTC](https://community.glideapps.com/t/date-formatting/2612 "2019-12-04T13:11:59Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Sandro\_Brito](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandro_brito/32/552_2.png) [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)\ **Post date:** [December 4, 2019, 1:11pm UTC](https://community.glideapps.com/t/date-formatting/2612/1 "2019-12-04T13:11:59Z")
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 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 4, 2019, 2:28pm UTC](https://community.glideapps.com/t/date-formatting/2612/2 "2019-12-04T14:28:07Z")
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")` ---
**Author:** ![Sandro\_Brito](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandro_brito/32/552_2.png) [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)\ **Post date:** [December 4, 2019, 4:06pm UTC](https://community.glideapps.com/t/date-formatting/2612/3 "2019-12-04T16:06:08Z")
Thank you so much @Jeff_Hager. Worked like a charm. ---
**Author:** ![Aj2666](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aj2666/32/1822_2.png) [@Aj2666](https://community.glideapps.com/u/Aj2666)\ **Post date:** [January 18, 2020, 12:22am UTC](https://community.glideapps.com/t/date-formatting/2612/4 "2020-01-18T00:22:57Z")
@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. How can I do that? ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [January 18, 2020, 12:45am UTC](https://community.glideapps.com/t/date-formatting/2612/5 "2020-01-18T00:45:51Z")
> [@Aj2666](#): > > Sun 16/01/2020 Would this formula work for you? Put your date in A3. ```auto =date(right(A3,4), mid(A3,8,2), mid(A3,5,2)) ``` ---
**Author:** ![Aj2666](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aj2666/32/1822_2.png) [@Aj2666](https://community.glideapps.com/u/Aj2666)\ **Post date:** [January 18, 2020, 7:58am UTC](https://community.glideapps.com/t/date-formatting/2612/6 "2020-01-18T07:58:48Z")
Perfect @George_B. That certainly solved my issue. Thanks ---
**Author:** ![Aj2666](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aj2666/32/1822_2.png) [@Aj2666](https://community.glideapps.com/u/Aj2666)\ **Post date:** [January 18, 2020, 8:18pm UTC](https://community.glideapps.com/t/date-formatting/2612/7 "2020-01-18T20:18:36Z")
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 =ArrayFormula(TIME(10,row(C1:C23)\*30,0)+C2) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 19, 2020, 5:35pm UTC](https://community.glideapps.com/t/date-formatting/2612/8 "2020-01-19T17:35:29Z")
Check out the Dates Example sheet here: > **[Copy of Copy of Directory](https://docs.google.com/spreadsheets/d/1zRj6vM46aiYvzvewuGFMMGcfkpOLmkOVQHL3tOoxV1o/edit?usp=sharing)** > > Admin > > UUID\_Profile,Admin,Signed Up Email,Name,Photo,Mobile No,Date joined > Admin,wepet365@gmail.com,Amjad...