Forum Discussion
Separate Date and Time From Timestamp in Calculated Column
I apologize in advance if this question has been aked before, but I've looked around and can't find the anwser that quite addresses my issue... I have a table in a tabula model with several datetime...
Hi Anonymous ,
If you want to create calculated columns, try this:
Date = [DateTime]Time = FORMAT([DateTime],"hh:mm:ss")
If you want to create custom columns, try this:
Date = Date.From([DateTime])Time = Time.From([DateTime])
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Thank you for this great visual answer. Makes it much easier to understand quickly. Thank you.