want to convert date from yyyy.mm.dd. format to dd.mm.yyyy. format

[Amar-Agnihotri]

Hello guys,

This code is giving date in format yyyy.mm.dd = Text.From(Date.Year(DateTime.LocalNow())-2)&"."&Text.End("0"&Text.From(Date.Month(DateTime.LocalNow())),2)&"."&Text.End("0"&Text.From(Date.Day(DateTime.LocalNow())),2)&"."

I want date in format  dd.mm.yyyy so i made following changes  - 

Text.From("0"&Text.From(Date.Day(DateTime.LocalNow())),2)&"."&Text.End("0"&Text.From(Date.Month(DateTime.LocalNow())),2)&"."&Text.End(Date.Year(DateTime.LocalNow())-2)&"."

Now i am getting an error  "we cannot convert the value 2 to type text ".

Will you please check what's wrong with my code.  

[mahoneypat · Accepted solution]

Please try this instead 

= Date.ToText(Date.From(DateTime.LocalNow()), "dd.MM.yyyy")

Pat

[Amar-Agnihotri]

Thanks for the Reply