Query M - get date and concatane - erros

[Anonymous]

Hello comunity,

Hope that you are doing well.

I would like to get a date and concatenate with , I would like the result having text format.

I did that, however I get this error. 

= let
Source1 =Text.Combine(Date.ToText(DateTime.Date(DateTime.LocalNow()),"yyyy-MM-dd"),"T00:00:00Z")
in
Source1
meta [IsParameterQuery=true, Type="Text", IsParameterQueryRequired=true]

I see that for using Text.Combine for In, this function receive as a List

I changed like that , then I cannot get a good result.

How can I get it ?

Thanks a lot.

[hnguy71]

Hi @Anonymous 

Try this instead:

let
    Source = DateTime.LocalNow(),
    DateOnly = Date.From(Source),
    AdjDateTime = Date.ToText(DateOnly, "yyyy-MM-ddT00:00:00Z")
in
    AdjDateTime

[Anonymous · Accepted solution]

When I finally had to post my problem, and I find a few minutes the result. 

Here is below. I add the " { } in the Text.combine because , it's considered as list.

Thanks, It could help someone else.