cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

Query Data for a Specific Date

Hi ,

 

I am new to Power Bi and I am trying some reporting stuffs with Power BI.

 

I am trying to query some data from a DB2 database which I have connected via the ODBC connections. My requirement here is to fetch data for the current date.

Take a look at a simple SQL query : 

select * from tablename where date = dt.

here date is the variable from my table and dt should be the current date that I want.

 

Any guidance.

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @VivekKakkoth 

 

Try using CURRENT DATE instead. Specifying CURRENT_DATE is equivalent to specifying CURRENT DATE.

SELECT * FROM tablename WHERE date = CURRENT DATE

Reference: https://stackoverflow.com/questions/32478642/how-to-select-data-from-db2-for-current-date 

 

In addition, Current date is in yyyy-mm-dd format. If your date column is in other format, you may need to convert its format. Please refer to https://stackoverflow.com/questions/10320918/db2-date-format 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

5 REPLIES 5
Syndicate_Admin
Administrator
Administrator

try this

 

SELECT * FROM table where DATE(date)=CURDATE()

Syndicate_Admin
Administrator
Administrator

Hi @VivekKakkoth ,

 

In Power Query M, you would bring in all the data, then filter as follows:

Table.SelectRows(
    previousStepName,
    each [date] = #date(2022, 05, 01)
    // OR: each [date] = variableName to use a defined variable
)

 

Pete

DATE(date)=CURDATE()

 

These formats are not working.. I had tried this option before I posted this requirement. It is throwing an SQL error as : 

 

Query1
ODBC: ERROR [42884] [IBM][CLI Driver][DB2] SQL0440N No authorized routine named "CURDATE" of type "" having compatible arguments was found. SQLSTATE=42884

Hi @VivekKakkoth 

 

Try using CURRENT DATE instead. Specifying CURRENT_DATE is equivalent to specifying CURRENT DATE.

SELECT * FROM tablename WHERE date = CURRENT DATE

Reference: https://stackoverflow.com/questions/32478642/how-to-select-data-from-db2-for-current-date 

 

In addition, Current date is in yyyy-mm-dd format. If your date column is in other format, you may need to convert its format. Please refer to https://stackoverflow.com/questions/10320918/db2-date-format 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

This Worked !!! 😃

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Kudoed Authors
Users online (1,588)