Forum Discussion
Combining Date columns
I have two date columns. Specifically, one date column is the "start date" the other is the "end date" both are formatted to display only the time. I was to combine these columns so that I have one...
Hi Anonymous,
Based on my test, you could refer to below ways:
You could use TIMEVALUE function to fetch the time data, refer to below formula:
Time = CONCATENATE(TIMEVALUE('Table1'[Date_Time_Start]),CONCATENATE("~",TIMEVALUE('Table1'[Date_Time_End])))Result:
Or you could use the RIGHT function to fetch the time value:
Time2 = CONCATENATE(RIGHT('Table1'[Date_Time_Start],11),CONCATENATE("~",RIGHT('Table1'[Date_Time_End],11)))Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He