Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Why this Power Query does not work?

Hello   Any idea why the Power Query below does not work?   #"Filter Today" = Table.Join(Table.TransformColumnTypes(Table.FromRecords({[Date = FormatDateTime.Date(DateTime.LocalNow())],[Date = Da...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous 

     

    As AlexisOlson mentioned, you need to replace FormatDateTime.Date() with DateTime.Date()

     

     

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

"FormatDateTime.Date" is not a valid function name.