Forum Discussion

ali_a's avatar
ali_a
Frequent Visitor
6 years ago
Solved

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 :)

 

 

 

Need Help
  • ali_a's avatar
    ali_a
    6 years ago

    I solved the problem by using the Advanced Editor 

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    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

     

  • ali_a's avatar
    ali_a
    Frequent Visitor
    6 years ago

    I solved the problem by using the Advanced Editor 

    • Shru's avatar
      Shru
      New Member
      3 years ago

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