Forum Discussion

Redlad1291's avatar
Redlad1291
Regular Visitor
7 years ago
Solved

Automatically setting todays date in query

Hi,   I currently have a table set up with a query where the date has to be changed manually every month i update it, What i want to do is get this to manually adjust everytime i refresh the data. ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    I believe what you want is:

     

    = Table.AddColumn(#"Expanded Period Table", "Custom", each DateTime.LocalNow() )
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

I believe what you want is:

 

= Table.AddColumn(#"Expanded Period Table", "Custom", each DateTime.LocalNow() )