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...
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.

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