# Date time column in joined list **URL:** \ **Category:** Ask for Help\ **Created:** [August 27, 2025, 3:25pm UTC](https://community.glideapps.com/t/date-time-column-in-joined-list/84056 "2025-08-27T15:25:21Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Abhinav\_Hans](https://avatars.discourse-cdn.com/v4/letter/a/4491bb/32.png) [@Abhinav\_Hans](https://community.glideapps.com/u/Abhinav_Hans)\ **Post date:** [August 27, 2025, 3:25pm UTC](https://community.glideapps.com/t/date-time-column-in-joined-list/84056/1 "2025-08-27T15:25:21Z")
Hi Everyone, I have a column in joined list which contains date, I need to add specific days which I have checked with if, like if payment is X when 30 if payment is Y then 60. The issue is coming when I am using math to add date with days, it is return a number only not a date and I suppose the joined list does not return the date as format in date. Any suggestions how to convert the joined list column into date. Thanks ---
**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:** [August 27, 2025, 3:34pm UTC](https://community.glideapps.com/t/date-time-column-in-joined-list/84056/2 "2025-08-27T15:34:17Z")
> [@Abhinav\_Hans](#): > > I suppose the joined list does not return the date as format in date This would be correct, but the way you are describing it and attempting to use a math column with the joined list column, it sounds like it only ever returns a single date. I guess my first questions would be…do you ever expect more than one value, and why are you using a joined list instead of a Lookup column or Single Value column ---
**Author:** ![Abhinav\_Hans](https://avatars.discourse-cdn.com/v4/letter/a/4491bb/32.png) [@Abhinav\_Hans](https://community.glideapps.com/u/Abhinav_Hans)\ **Post date:** [August 27, 2025, 3:41pm UTC](https://community.glideapps.com/t/date-time-column-in-joined-list/84056/3 "2025-08-27T15:41:11Z")
So, I have a payment table which includes this all information, while in user table I have query create to display the latest payment for which I am using look up form query, and then converting this to joined list to use for calculations. so it will always be one value as query is restricted to 1. ---
**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:** [August 27, 2025, 3:48pm UTC](https://community.glideapps.com/t/date-time-column-in-joined-list/84056/4 "2025-08-27T15:48:24Z")
I would just change the query to only return a single row in the query column configuration, and then use the lookup column, which will be a single date type value instead of an array. Turn this off. ![1000005753](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/7/47149c2343d197e1cfb2c41163b207ed850800ea.jpeg) On a side note, you never need to create a joined list on top of a lookup. You could skip a step and have the joined list directly refer to the relation or query instead. You don’t need a joined list in this case, but just wanted to make you aware. ---
**Author:** ![Abhinav\_Hans](https://avatars.discourse-cdn.com/v4/letter/a/4491bb/32.png) [@Abhinav\_Hans](https://community.glideapps.com/u/Abhinav_Hans)\ **Post date:** [August 27, 2025, 3:56pm UTC](https://community.glideapps.com/t/date-time-column-in-joined-list/84056/5 "2025-08-27T15:56:20Z")
Thanks Jeff, it worked. ---
**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:** [September 3, 2025, 3:57pm UTC](https://community.glideapps.com/t/date-time-column-in-joined-list/84056/6 "2025-09-03T15:57:02Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.