Forum Discussion

TonyHansson's avatar
TonyHansson
Frequent Visitor
3 years ago
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"]) + #...
Need Help
  • HotChilli's avatar
    HotChilli
    3 years ago

    You could try constructing a datetime and hardcoding the time .

    Here's a start:

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

TonyHansson's avatar
TonyHansson
Frequent Visitor
3 years ago

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)