How to use current date in SQL query while connecting from Lumira to SAP

[arunsriv]

Hi -

I am connecting from Lumira to SAP and trying to retrieve some data using SQL (underlying database is Oracle). Everything works fine if I use a hardcoded date value but I need to use a dynamic date in SQL and I do not know how can I get that working. Here's the SQL that is working...

select * from <infosetname> where "infoset.SLFDAT" > DATE'2017-01-01'

My requirement is to get all the records for rolling 3 months and therefore, I need something like...

select * from <infosetname> where "infoset.SLFDAT" > [current date - 90 days]

I am not familiar with the freehand SQL...so, looking for some assistance.

Can someone please help!

Thanks,

Arun

[former_member183750]

Does the query (select * from <infosetname> where "infoset.SLFDAT" > [current date - 90 days]) work in Oracle?

Does it work in IDT?

- Ludek Senior Support Engineer AGS Product Support, Global Support Center Canada

SAP is now offering chat support for specific product components. For more details please see the KBA 2213344 - How to start a chat with SAP Support[video]

Follow me on Twitter: https://twitter.com/crnanalysistips

Got Enhancement ideas? Use the SAP Idea Place: https://ideas.sap.com/SAPLumira/boards

[arunsriv]

Anyone? Hope this is the right forum to post the question...