I have a database table with a date field called 'ENDDAT'
How do I write a select query that selects all records whose difference between sy-datum and 'ENDDAT' is greater than 7.
If I do the normal date comparison for eg.
select * from <databasetable> where enddat - sy-datum > 7
select * from <databasetable> where (enddat - sy-datum) > 7
It throws error that '-' is not a valid comparison operator.
Can anyone help????