Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

date selection in query : logic needed!


we have one calendar day depending on which the query result is displayed!

Now the requirement is such that when user enters one date the query has to generate the result for the multiple date ranges including the one which he has entered.

example: if user has entered 15/9/2007 then query should not only display the result of the date 15/9/2007 but also the results of -5 to +2 ( means 10/9,11/9,12/9,13/9 and 14/9 plus 16/9 and 17/9 )

simlarly other ranges like -8 to + 7 and so on

How to define this in query?



Not what you were looking for? View more on this topic or Ask a question