How To Get Current Date in Power Query?
Power query is a analysis tool in excel.From 2016 version onwards it was inbuilted in the Excel . Power Query helps us to perform all type of tasks regarding to transformation. In this article is we will see how to get current date in power query .
Getting Current Date in Power Query
To get the current date in Power Query,we use the function “=Date.From(DateTime.LocalNow())” in the Formula bar of the power Query Editor.
Let’s begin our task to create a new query in power query editor to get the Current Date.with this we will also learn some more functions to genarate queries related to time,Date etc…
Step 1: Open a new workbook in Excel and go to the Power Query Editor by clicking on the ‘Data’ tab and selecting ‘From Other Sources’ > ‘Blank Query.’
Step 2: Now add function “=Date.From(DateTime.LocalNow())” in the Formula bar of Power Query
Step 3: To add another query cliccking on query box selecting ‘New Query’>’Other Sources’>Blank Query .
Step 4 : Follow step 2 Now add Function “=DateTime.LocalNow()” .
Step 5: Click on the ‘Close & Load’ button to save the changes and load the data into Excel.
Output:
In the above example, we have used the “ =Date.From(DateTime.LocalNow())” function to get the current date and we have used “=DateTime.LocalNow()” ,this function to genarate both Date and time in the local time zone.
For more Functions Related to Date Functions Click on Date Functions.
Contact Us