Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Is it possible to store DateTime.LocalNow() as a scalar variable without creating new column?

Hi there, this problem has had me stuck for a little while. 

All I'm trying to do is filter the table so that it keeps rows with a date greater than 7 days old. To do so, I'm simply using the [Date] column from the table and comparing it to DateTime.LocalNow()

Previously, I generated a new column and compared the dates that way:

(note: I recognize both functions reference #"Filter Packet Turned In" but it's just a quick recreation of what I had)

However I'm wondering if there is way to avoid generating a new column and instead store the current day as a variable/function that can be referenced. I tried the process below but got the following error:



Appreciate any help!

Need Help
  • HotChilli's avatar
    HotChilli
    5 years ago

    Something like this (with your own fields):

    = Table.SelectRows(#"previous Step", each Duration.Days(  Date.From(DateTime.LocalNow()) - [Date] ) >  7)

4 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    5 years ago

    Something like this (with your own fields):

    = Table.SelectRows(#"previous Step", each Duration.Days(  Date.From(DateTime.LocalNow()) - [Date] ) >  7)
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Ok so the Date.From(DateTime.LocalNow()) has to be called in the Table function? It can't be stored as its own seperate variable and be called like I showed in my example?

       

  • HotChilli's avatar
    HotChilli
    Community Champion
    5 years ago

    You can declare a variable if you want to:

     

    let thedate = Date.From(DateTime.LocalNow()) in

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Alright so the variable 'thedate' needs to be in it's own let-in environment, seperate (or nested) from the main let-in environment of the query?