Power Query Todays date minus 1 day

[cottrera]

Morning 

I need to create a custom column that dsiplays Todays date minus 1 day.  I thought it might look someting like this

=Date.AddDays(DateTime.FixedLocalNow())-1

but this dispalys and error.

thank you

Richard

[AlB]

Hi @cottrera 

Date.AddDays(Date.From(DateTime.FixedLocalNow()), -1 )

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[cottrera]

Great works fine thank you for responding so quick;y 😀

[serpiva64 · Accepted solution]

Hi,

this functions

Date.AddDays( DateTime.FixedLocalNow(),-1))

control your parenthesis