# How to get a DateTime column from a DateOnly and TimeOnly columns **URL:** \ **Category:** Ask for Help\ **Created:** [July 2, 2023, 8:08pm UTC](https://community.glideapps.com/t/how-to-get-a-datetime-column-from-a-dateonly-and-timeonly-columns/63412 "2023-07-02T20:08:09Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![TeamDigitale](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teamdigitale/32/13473_2.png) [@TeamDigitale](https://community.glideapps.com/u/TeamDigitale)\ **Post date:** [July 2, 2023, 8:08pm UTC](https://community.glideapps.com/t/how-to-get-a-datetime-column-from-a-dateonly-and-timeonly-columns/63412/1 "2023-07-02T20:08:09Z")
Hi, i have 2 columns that store a DateOnly and a TimeOnly value. I have tried to use these columns as source for a Calendar’s collection but i don’t know how to get a column that “combine” the Date and Time columns ini a DateTime columns How can i do this ? Thanks in advance ---
**Author:** ![GrumpyRick](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grumpyrick/32/18079_2.png) [@GrumpyRick](https://community.glideapps.com/u/GrumpyRick)\ **Post date:** [July 2, 2023, 8:22pm UTC](https://community.glideapps.com/t/how-to-get-a-datetime-column-from-a-dateonly-and-timeonly-columns/63412/2 "2023-07-02T20:22:08Z")
Use a template column and put both columns in it for a Date&Time column. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [July 2, 2023, 9:26pm UTC](https://community.glideapps.com/t/how-to-get-a-datetime-column-from-a-dateonly-and-timeonly-columns/63412/3 "2023-07-02T21:26:47Z")
Yes. 1. template column to Combine the two 2. text to Date column to covert to date (optional but recommended to leverage date logic) 3. Use this column in the calendar component ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [July 2, 2023, 9:55pm UTC](https://community.glideapps.com/t/how-to-get-a-datetime-column-from-a-dateonly-and-timeonly-columns/63412/4 "2023-07-02T21:55:39Z")
> [@TeamDigitale](#): > > i have 2 columns I wonder why you would have 2 columns in the first place, but perhaps that is something you have little to no control over? ---
**Author:** ![GrumpyRick](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grumpyrick/32/18079_2.png) [@GrumpyRick](https://community.glideapps.com/u/GrumpyRick)\ **Post date:** [July 3, 2023, 1:19am UTC](https://community.glideapps.com/t/how-to-get-a-datetime-column-from-a-dateonly-and-timeonly-columns/63412/5 "2023-07-03T01:19:44Z")
Unrelated to this thread, but for me it was due to a scheduling function. Date is chosen first and then available time slots are displayed (filtering out those already taken). ---
**Author:** ![TeamDigitale](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teamdigitale/32/13473_2.png) [@TeamDigitale](https://community.glideapps.com/u/TeamDigitale)\ **Post date:** [July 3, 2023, 8:45am UTC](https://community.glideapps.com/t/how-to-get-a-datetime-column-from-a-dateonly-and-timeonly-columns/63412/6 "2023-07-03T08:45:55Z")
HI, how can i convert the template column to date/time column ? Thanks again ---
**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:** [July 3, 2023, 8:55am UTC](https://community.glideapps.com/t/how-to-get-a-datetime-column-from-a-dateonly-and-timeonly-columns/63412/7 "2023-07-03T08:55:26Z")
> [@Robert\_Petitto](#): > > text to Date column to covert to date (optional but recommended to leverage date logic) > **[Text to Date column | Glide](https://www.glideapps.com/plugins/parse-date)** > > Convert text to a date. ---
**Author:** ![TeamDigitale](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teamdigitale/32/13473_2.png) [@TeamDigitale](https://community.glideapps.com/u/TeamDigitale)\ **Post date:** [July 3, 2023, 10:46am UTC](https://community.glideapps.com/t/how-to-get-a-datetime-column-from-a-dateonly-and-timeonly-columns/63412/9 "2023-07-03T10:46:21Z")
Ok, i have tried to combine the 2 columns in one template columns, but i cannot get any valid result. i have tried 2/7/2023, 9:00 2/7/2023 9:00 2/7/2023 9:00 PM with no success which format must i use ? Thanks again ---
**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:** [July 3, 2023, 11:19am UTC](https://community.glideapps.com/t/how-to-get-a-datetime-column-from-a-dateonly-and-timeonly-columns/63412/10 "2023-07-03T11:19:05Z")
Any of those should work, you just need to provide the correct pattern according to the format that you use. For example, with 2/7/2023, 9:00 you would use d/M/yyyy, h:mm ![CleanShot 2023-07-03 at 19.17.24@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/56c50299db40e7e847a0abd72f8beabb6c38ed37.png) You may also need to provide a UTC offset, depending on where you are. In my case, I’m in Singapore, so I use `utc-8`. ---
**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:** [July 4, 2023, 11:19am UTC](https://community.glideapps.com/t/how-to-get-a-datetime-column-from-a-dateonly-and-timeonly-columns/63412/11 "2023-07-04T11:19:24Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.