Forum Discussion

Medmbchr's avatar
Medmbchr
Icon for Helper IV rankHelper IV
3 years ago
Solved

Combined 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