Status of Tickets based on their Dates

Scenario:

Sometimes we may get the requirement to find the status of ticket based on their created on and closed date.This document can be applicable for any object which has some validity period and we need to find the status of it based on any date.

Lets say for eg:

So now if user enter any date in between those two dates then we need to get the status of the same.

The approach which we can follow to achieve the same will be sharing with you with all the steps and screenshots.

Data Sheet:

Data Loaded in DSO:

Step 1–Go to  BEx Query Designer–Drag and Drop Created on date in Characteristic Restrictions panel–Right click on Created date—Restrict–Show–Value ranges—Less than or equal to–Choose the variable 0I_DAYWT (User input variable).

Step 2—Now drag and drop Closing Date in Characteristic Restrictions panel–Right click on Closing date–Restrict–Variable–Create new variable.Refer the screenshot for details.

Hit the Replacement Path tab and give the details as mentioned in below screenshot

Now Save this variable.

Restrict the Closing date with the newly created variable as shown in below screenshot.

Users also need to see the date which has been entered by them on Selection screen in Query Columns as well.So for that our approach will be explained in furhter steps.

Step 3—Go to Columns panel in query designer create a new formula–Under Available Operands–Formula variable–Right click–New variable.Refer the Screenshot for reference.

Hit the Replacement Path tab and give the details as mentioned in below screenshot

Hit the Currency/Unit tab and give the details as mentioned in below screenshot.

Save this Variable and use it in your formula.

Query Format

Variable Screen:

Query Output:

So you can see based on the input date we got the status of tickets and also we got the date entered by user on selection screen in User Input column.

Hope this will be helpful.