help with oracle query for date type

[ali_a]

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 🙂

[ali_a · Accepted solution]

I solved the problem by using the Advanced Editor 

[Shru]

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

[v-juanli-msft]

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