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)
Go to Solution.
You could try constructing a datetime and hardcoding the time .
Here's a start:
View solution in original post
You could also use DateTime.ToText and DateTime.FromText like this:
DateTime.FromText(DateTime.ToText([Column], [Format="yyyy-MM-dd 15:00:00"]))
Worked perfect Thank you
#datetime(Date.Year([#"M&P deadline"]),Date.Month([#"M&P deadline"]),Date.Day([#"M&P deadline"]),15,00,00)
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!