# Array with all dates in between **URL:** \ **Category:** Ask for Help\ **Created:** [February 4, 2023, 9:29pm UTC](https://community.glideapps.com/t/array-with-all-dates-in-between/57508 "2023-02-04T21:29:54Z")\ **Posts on this page:** 8\ **Page:** 2
**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\ **Post date:** [February 5, 2023, 7:34pm UTC](https://community.glideapps.com/t/array-with-all-dates-in-between/57508/22 "2023-02-05T19:34:33Z")
You guys are awesome! Thanks a lot for all the tips. ---
**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\ **Post date:** [May 11, 2024, 7:27am UTC](https://community.glideapps.com/t/array-with-all-dates-in-between/57508/23 "2024-05-11T07:27:22Z")
Is there a way to return the date values back to actuall dates in an array form? ---
**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:** [May 11, 2024, 1:41pm UTC](https://community.glideapps.com/t/array-with-all-dates-in-between/57508/24 "2024-05-11T13:41:15Z")
What’s your use case? What are you trying to do with the array of dates? ---
**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\ **Post date:** [May 11, 2024, 4:49pm UTC](https://community.glideapps.com/t/array-with-all-dates-in-between/57508/25 "2024-05-11T16:49:54Z")
I need to separate dates in which a student attended class from the dates in a period (in this case the period is a school term) so to know which actual dates the students were absent from school. I’m using a remove elements array from the array in between dates to remove the dates the student was present at school. But then the dates are in number form so the user will not be able to tell which dates the particular student missed class. Hence the need to convert them back to normal dates and then display as an inline list against the student ---
**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:** [May 11, 2024, 11:45pm UTC](https://community.glideapps.com/t/array-with-all-dates-in-between/57508/26 "2024-05-11T23:45:20Z")
What type of “number form” are you using? ---
**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\ **Post date:** [May 13, 2024, 8:51am UTC](https://community.glideapps.com/t/array-with-all-dates-in-between/57508/27 "2024-05-13T08:51:29Z")
The date number that results from the TRUNC(date) function ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 13, 2024, 9:05am UTC](https://community.glideapps.com/t/array-with-all-dates-in-between/57508/28 "2024-05-13T09:05:44Z")
I believe that `Trunc(Date)` gives you the equivalent of an Excel serialised date value, which is essentially the number of days since Jan 1 1900. There is probably a way to convert that back to a date - maybe an Excel function? (I don’t use Excel). Personally, if you want to store the dates as numbers, I would suggest something a bit more user friendly. My recommendation would be YYYYMMDD. You can get that with the following math formula: ```auto Year(Date)*10^4 + Month(Date)*10^2 + Day(Date) ``` Converting that back to an actual date value at a later stage is trivial with a Text to Date column. ---
**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:** [May 13, 2024, 2:14pm UTC](https://community.glideapps.com/t/array-with-all-dates-in-between/57508/29 "2024-05-13T14:14:37Z")
Also that date format Darren suggested is much more readable, in case you like it enough and don’t need to convert to another form. [Previous page](https://community.glideapps.com/t/array-with-all-dates-in-between/57508.md?page=1)