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
Use a template column and put both columns in it for a Date&Time column.
Yes.
- template column to Combine the two
- text to Date column to covert to date (optional but recommended to leverage date logic)
- Use this column in the calendar component
I wonder why you would have 2 columns in the first place, but perhaps that is something you have little to no control over?
1 Like
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).
1 Like
HI,
how can i convert the template column to date/time column ?
Thanks again
2 Likes
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
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
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.
5 Likes
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.