Forum Discussion
Solved
Change date and time
Hi I have a column with a date and time. I need to keep the date, but change the time to always be 15:00 I have tried different but no luck. Custom column = Date.From([#"Column"]) + #...
You could try constructing a datetime and hardcoding the time .
Here's a start:
#datetime(Date.Year([Column1]), Date.Month([Column1].....
You could also use DateTime.ToText and DateTime.FromText like this:
DateTime.FromText(DateTime.ToText([Column], [Format="yyyy-MM-dd 15:00:00"]))