Forum Discussion
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.
The query i currently have is:
= Table.AddColumn(#"Expanded Period Table", "Custom", each "11/01/2019")
is there a forumla or a way to adapt this query so it just updates whenever i refresh the data in BI?
I believe what you want is:
= Table.AddColumn(#"Expanded Period Table", "Custom", each DateTime.LocalNow() )
1 Reply
I believe what you want is:
= Table.AddColumn(#"Expanded Period Table", "Custom", each DateTime.LocalNow() )