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
Hi Anonymous,
Based on my test, you could refer to below formula:
Time = CONCATENATE('Table1'[Date_Time_Start],CONCATENATE("~",'Table1'[Date_Time_End]))
Result:
Regards,
Daniel He
Thank you.