# Change number format to date **URL:** \ **Category:** Ask for Help\ **Created:** [October 1, 2024, 9:07pm UTC](https://community.glideapps.com/t/change-number-format-to-date/76743 "2024-10-01T21:07:49Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\ **Post date:** [October 1, 2024, 9:07pm UTC](https://community.glideapps.com/t/change-number-format-to-date/76743/1 "2024-10-01T21:07:49Z")
Hello everyone! Hoping you are all doing well, I have a series of columns that extract certain specific days of the month, but I would like it to be in date format. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/0/c0ec704201fb7efbb2bf0071c61d1aa794bf2813.png) Has anyone done something like this before? where I can display in date format 05/10/2024 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 1, 2024, 11:56pm UTC](https://community.glideapps.com/t/change-number-format-to-date/76743/2 "2024-10-01T23:56:09Z")
Can you share more on the logic here? Your “Hoy” column is a date, and if you want “DÍA CINCO” to always be the 5th date of the month, it can just be Hoy + 4. ---
**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\ **Post date:** [October 2, 2024, 11:44am UTC](https://community.glideapps.com/t/change-number-format-to-date/76743/3 "2024-10-02T11:44:46Z")
Look, what happens is that I can’t apply “today + 4”, because if for example today is October 2, but if I do today + 4 then it would give me the 6th, and I want it to take the 5th, 15th, 28th and 30th of the current month. I don’t know if I make myself clear? I mean, basically I want to get the dates of the 5th, 15th, 28th and 30th of the current month, but if I do the sum then it wouldn’t work because the days go by and then it would no longer show 5 but another day. ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [October 2, 2024, 12:30pm UTC](https://community.glideapps.com/t/change-number-format-to-date/76743/4 "2024-10-02T12:30:08Z")
You could construct the date yourself. To get the current month use the formula month(Date) Then use template columns to add the 5th 15th 28th and 30th to it. ---
**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:** [October 2, 2024, 1:22pm UTC](https://community.glideapps.com/t/change-number-format-to-date/76743/5 "2024-10-02T13:22:48Z")
Use this in a math column with your starting date. `Date-Day(Date)+5` ---
**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\ **Post date:** [October 2, 2024, 6:26pm UTC](https://community.glideapps.com/t/change-number-format-to-date/76743/6 "2024-10-02T18:26:43Z")
It could be a very good option, but the thing is that I want this to be for all months, that is, when it is November I also want to have the dates of November 5, 15, 28 and 30. With what you tell me your Date-Day(Date)+5 the thing is that this works when I have a start date, but here there is no start date, since I want to take from the current month the 5th, 15th, 28th and 30th. ---
**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\ **Post date:** [October 2, 2024, 6:27pm UTC](https://community.glideapps.com/t/change-number-format-to-date/76743/7 "2024-10-02T18:27:14Z")
Could you be a little more specific about the assembly? I understand the idea but I haven’t been able to do it yet. ---
**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:** [October 2, 2024, 6:32pm UTC](https://community.glideapps.com/t/change-number-format-to-date/76743/8 "2024-10-02T18:32:13Z")
Today (Now) can be a start date. It will calculate dynamically based on the current year and month of today. Any date can be used as long as it’s an actual date. Your screenshots indicate that you have some sort of base date to start from. My solution is really no different than yours, but a whole lot simpler. You are already grabbing year and month from a date and trying to append a day number, which is fine, but doesn’t lead to a real date. My solution does the same thing but results in a real date. If your Hoy column is supposed to represent today, then you can get rid of it and do it all in one column. Use my formula and replace date with the ‘Now’ special value. If that’s not what you want, you will need to explain more. Are you trying to calculate dates for just the current month? For all months in the future? All months in the past? ---
**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\ **Post date:** [October 2, 2024, 7:23pm UTC](https://community.glideapps.com/t/change-number-format-to-date/76743/9 "2024-10-02T19:23:56Z")
You are so right Jeff! I have already understood your point of view, and it is exactly what I was looking for, I already understood that what you are doing is subtracting the date from the date and then adding the day that I want to extract in this case 5,15,28 and 30. The truth is that it worked. Another question, do you know if it is possible to show these dates in a choice element? That is, all the dates 5,15,28,30 to show them in a choice element? I understand that the choice works for data in columns. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/7/97ee27ad74fa3b43aa87f0b171450358977c22c9.png) ---
**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:** [October 2, 2024, 7:26pm UTC](https://community.glideapps.com/t/change-number-format-to-date/76743/10 "2024-10-02T19:26:50Z")
If you want to use them as choices, then I would create a 4 row table. In each row have a column with the day number you want. Then add the math column. You will have 4 rows with each unique date in each row. You should only need two columns. One for day number and one for the math with a reacement value to use that day number. Build your choices down instead of across. The choice component requires data in rows. PS. Be aware that February will bite you if you are attempting to use 30. ---
**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\ **Post date:** [October 2, 2024, 7:37pm UTC](https://community.glideapps.com/t/change-number-format-to-date/76743/11 "2024-10-02T19:37:40Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/3/9352d9972ba53b2a0193f34fdf0a8e366345174c.png) Thank you very much Jeff for your support, I have achieved the goal I was looking for! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [October 9, 2024, 7:38pm UTC](https://community.glideapps.com/t/change-number-format-to-date/76743/12 "2024-10-09T19:38:33Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.