Forum Discussion
Medmbchr
Helper IV
3 years agoCombined Datetime column from separate Date & Time
Hi,
I have a column in which I would like to display the following: 01/01/2022 18:00:00
This value should come from:
- A column: 01/01/2022 00:00:00
- A measure: 18:00:00 (which I made using mymeasure=TIME(HH,MM,SS)
When I do DATETIME(mycolumn&" "&mymeasure) it gives me 01/01/2022 00:00:00 without taking into consideration the time value.
Any idea how to combine these two?
1 Reply
- DataInsights
Super User