Forum Discussion

annaamalaim's avatar
annaamalaim
Frequent Visitor
9 years ago
Solved

Table level filter for dates

Hi All,   I have to filter my the report within the current date and it should not exceed the current date and display the date.I have found the below query as a solution   = Table.SelectRows(#"R...
General Comment
  • annaamalaim's avatar
    annaamalaim
    9 years ago

    Hi 

     

    I got a solution by using the below code

     

    = Table.SelectRows(#"Changed Type", each [Appointment Date By] <= #datetime(Date.Year(DateTime.LocalNow()), Date.Month(DateTime.LocalNow()) ,Date.Day(DateTime.LocalNow()), 23, 59, 0))

     

    Now the date has been filtered !!

     

    - Anna

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

annaamalaim

 

= Table.SelectRows(#"Expanded NewColumn", each [Repair Completion Date] <= Date.From(DateTime.LocalNow()))

 

i ran this and had no issues on it - my repair completion is a DateTime

 

 

  • annaamalaim's avatar
    annaamalaim
    Frequent Visitor
    9 years ago

    Hi 

     

    I got a solution by using the below code

     

    = Table.SelectRows(#"Changed Type", each [Appointment Date By] <= #datetime(Date.Year(DateTime.LocalNow()), Date.Month(DateTime.LocalNow()) ,Date.Day(DateTime.LocalNow()), 23, 59, 0))

     

    Now the date has been filtered !!

     

    - Anna

  • annaamalaim's avatar
    annaamalaim
    Frequent Visitor
    9 years ago

    Hi 

     

    I got a solution by using the below code

     

    = Table.SelectRows(#"Changed Type", each [Appointment Date By] <= #datetime(Date.Year(DateTime.LocalNow()), Date.Month(DateTime.LocalNow()) ,Date.Day(DateTime.LocalNow()), 23, 59, 0))

     

    Now the date has been filtered !!

     

    - Anna