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
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Kudoed Authors
Users online (5,238)