Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Query M - get date and concatane - erros

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.

 

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.

  • hnguy71's avatar
    hnguy71
    Icon for Super User rankSuper User
    1 year ago

    Hi Anonymous 

    Try this instead:

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