Dynamic date range 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

[arunsriv]

Thanks Ludek - No luck so far...!

Here's the actual SQL that works...

Now I changed DATE'2015-12-12' to (SYSDATE) and getting the following error.

What could be other options for me to try?

Arun

[former_member183750]

I think it would be something like:

SELECT count (licences.LICENCEID) FROM licences, product_codes WHERE (LICENCES.STARTDATE <= (SYSDATE)) AND (LICENCES.STARTDATE >= (SYSDATE - (90)))

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada