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"]) + #duration(0,15,0,0)
Regards
Tony
You could try constructing a datetime and hardcoding the time .
Here's a start:
#datetime(Date.Year([Column1]), Date.Month([Column1].....
3 Replies
Hi HotChilli
Worked perfect Thank you
#datetime(Date.Year([#"M&P deadline"]),Date.Month([#"M&P deadline"]),Date.Day([#"M&P deadline"]),15,00,00)
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"]))
