Open In App

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy

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:

Current Date and Current Date and Time in Power Query

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.

Article Tags :
SQL
Recommended Articles
1. How to Get Current Date and Time in SQL?
2. How To Get the Current Date (Without Time) in T-SQL?
3. How to Write a SQL Query For a Specific Date Range and Date Time?
4. SQL Query to Get a Financial Year Using a Given Date
5. SQL Query to Add Email Validation Using Only One Query
6. SQL Query to Find the Year from Date
7. SQL Query to Check Given Format of a Date
8. SQL Query to Convert Date Range to Per Day Records
9. SQL Query to Convert Datetime to Date
10. SQL Query to Check if Date is Greater Than Today in SQL
11. SQL Query to Compare Results With Today's Date
12. SQL Query to Convert Date to Datetime
13. SQL Query to Convert Date Field to UTC
14. SQL Query to Delete a Data From a Table Based on Date
15. SQL Query to Get Yesterday and Tomorrow
16. SQL Query to get first and last day of a month in a Database
17. SQL Query to get information of employee where employee Is Not Assigned to the Department
18. SQL Query to Get Distinct Records Without Using Distinct Keyword
19. SQL Query to Get First and Last Day of a Week in a Database
20. SQL Query to Get the Latest Record from the Table
21. SQL Query to Get Column Names From a Table
22. SQL Query to Get Only Numbers From a String
23. How to Get Multiple Counts With One SQL Query?
24. List the available Databases for Current User in SQL SERVER
25. How to Update Current Timestamp in MySQL?