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 Columns3", each [Time Date] >= #date(2022,1,1))

 

It was replaced with the following

= Table.SelectRows(#"Renamed Columns3", each [Time Date] >= #date(#"Filter Date"))

 

I get this error

Expression.Error: 1 arguments were passed to a function which expects 3.
Details:
Pattern=
Arguments=[List]

 

Below is the Value of Filter Date:

1/1/2022 12:00:00 AM

 

Any ideas?

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 

1 Reply

  • jbwtp's avatar
    jbwtp
    Memorable 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