Change date and time

[TonyHansson]

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

[AlexisOlson]

You could also use DateTime.ToText and DateTime.FromText like this:

DateTime.FromText(DateTime.ToText([Column], [Format="yyyy-MM-dd 15:00:00"]))

[TonyHansson]

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)

[HotChilli · Accepted solution]

You could try constructing a datetime and hardcoding the time .

Here's a start:

#datetime(Date.Year([Column1]), Date.Month([Column1].....