Dynamic date/time change

Hi vicky_ 

Thanks for responding. Looks like that returns only the date.

Hi dave_schultz ,

Try the Date.StartOf Day function. It returns the start of the day represented by dateTime. dateTime must be a date, datetime, or datetimezone value.

let
Source = DateTime.LocalNow(),
#"Converted to Table" = #table(1, {{Source}}),
#"Added Custom1" = Table.AddColumn(#"Converted to Table", "Custom.1", each Date.StartOfDay(Date.AddDays([Column1],-2)))
in
    #"Added Custom1"

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.