Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ali_a
Frequent Visitor

help with oracle query for date type

I have a function has three parameters as you can see below in the code of oracle query. I want to pass the date as a parameter but not working as this one&nbsp '"&DueDate&"' if I add date without parameter will be work as this one

 

'31122018'
SELECT SUM
(db.acc_data.get_mat(c.brnch_No,
c.ContractNo,
db.dat (db.dtpkg.g2h (TO_DATE ('"&DueDate&"','ddmmyyyy'))))) as sum
FROM db.brnchtable c
WHERE (acc.get_brnchtype (c.brnch_No) = 1)

 

now I want to use the date as a parameter. I need your help 🙂


more info about '"&DueDate&"' not show data 🙂

 

test1.PNG

 

test2.PNG

 

1 ACCEPTED SOLUTION
ali_a
Frequent Visitor

I solved the problem by using the Advanced Editor 

View solution in original post

3 REPLIES 3
ali_a
Frequent Visitor

I solved the problem by using the Advanced Editor 

How did u solve this problem I am facing the same issue please help.

v-juanli-msft
Community Support
Community Support

Hi @ali_a 

DueDate is a parameter created in Power BI or in Oracle?

What is its type?

 

This code is correct or not?

'31122018'
SELECT SUM
(db.acc_data.get_mat(c.brnch_No,
c.ContractNo,
db.dat (db.dtpkg.g2h (TO_DATE ('"&DueDate&"','ddmmyyyy'))))) as sum
FROM db.brnchtable c
WHERE (acc.get_brnchtype (c.brnch_No) = 1)

If it is not correct, how about use this code

TO_DATE ("&DueDate&",'ddmmyyyy')

Best Regards
Maggie

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.