Forum Discussion

PSupanich's avatar
PSupanich
New Member
3 years ago
Solved

Passind a Date Parameter for a Filter -Error

I have a Connection Only Parameter Called "Filter Date" that I am am referencing in another Query to Filter a By Date.    This is the original code that was edited = Table.SelectRows(#"Renamed Col...
Need Help
  • jbwtp's avatar
    jbwtp
    3 years ago

    Hi PSupanich,

     

    the #date funciton that is used in the example does take 3 parameters: year, month and day. It fails because #"Filter date" only contains 1 element - the date itself. You do not really need #date here, rahter Date.From used like Date.From(#"Filter date").

     

    Cheers,

    John 

jbwtp's avatar
jbwtp
Icon for Memorable Member rankMemorable Member
3 years ago

Hi PSupanich,

 

the #date funciton that is used in the example does take 3 parameters: year, month and day. It fails because #"Filter date" only contains 1 element - the date itself. You do not really need #date here, rahter Date.From used like Date.From(#"Filter date").

 

Cheers,

John