How to convert todays date to text, with a specific format ?

[edubcardoso]

I need to convert the current date to text so i can join it to a string.

let
    Source = DateTime.LocalNow(),
    Text = DateTime.ToText(Source)       
in
    Text

I have this, but the output is 09/09/2022 12:31:23 and I need 2022-09(MONTH)-09(DAY)

How can I solve this ?

[Vijay_A_Verma · Accepted solution]

Change DateTime.ToText(Source) to

DateTime.ToText(Source,"yyyy-MM-dd")

[ronrsnfld · Accepted solution]

Depending on exactly what you want, maybe:

 DateTime.ToText(DateTime.LocalNow(),"yyyy-MM(MMMM)-dd(dddd)") 
      => 2022-09(September)-09(Friday)

or

DateTime.ToText(DateTime.LocalNow(),"yyyy-MM(""MONTH"")-dd(""DAY"")") 
     => 2022-09(MONTH)-09(DAY)

here, today.

[Vijay_A_Verma · Accepted solution]

Change DateTime.ToText(Source) to

DateTime.ToText(Source,"yyyy-MM-dd")