Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
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
Solved! Go to Solution.
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"]))
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].....