Power Query change date format to dd/mm/yyyy

I get this below, which makes me wonder if the formula returns the format defined by the operating system in the regional settings.

EDIT:

Date.ToText(date, "mm/dd/yyyy")

Thanks. The data/table that is created is moved to a Template that is used to upload information into another software program. Thats the program that needs the date in a specific format. I tried to change the format on the excel tab / table but that didn't work when I tried to push the data to the other Software. just for clarity, where I created the new column I should change the formula from: = =DateTime.LocalNow() to: Date.ToText(date, "mm/dd/yyyy") Sorry, relatively new to Excel Power Query.

I really appreciate your help

= Table.AddColumn(#"Added Custom Resource", "Created", each Date.ToText(Date.From(DateTime.LocalNow()), "mm/dd/yyyy")) In the applied steps (adding a new column under the formula, I added this: =Date.ToText(Date.From(DateTime.LocalNow()), "mm/dd/yyyy") But this formula is resulting in a value of 00/18/2021 it should be 08/18/2021 Not sure what I did wrong.

Thanks

OK I changed it to: = Table.AddColumn(#"Added Custom Resource", "Created", each Date.ToText(Date.From(DateTime.LocalNow()), "MM/dd/yyyy")) capitalizing the MM made a difference

THANK YOU FOR YOUR HELP

Most welcome. Thanks for the feedback. Never thought "MM" makes such difference. Learned from this too. ?

Thanks for the Intel, that's good to know. Strangely enough, it seemed to work on my end with just mm not MM.
Need to look into it some more.