cancel
Showing results for 
Search instead for 
Did you mean: 

Greater than 90 Days

Former Member
0 Kudos

Hi ,

I have a characteristic ZMANUDATE.

Basically, I need to provide a query whereby only materials which have been manufactured greater than 90 days ago

Please advice

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member184494
Active Contributor
0 Kudos

Chris,

The best option for that would be to use

0CALDAY - restrict it by SAP Exit 0DATE ( this restricts by current system date ) and then use an offset of -90.

Otherwise you would have to use some exits for the same...

Arun

Former Member
0 Kudos

Cheers Arun,

My concern is if I was to offset by -90 , would this result

1) show me all the machines which were produced at exactly 90 days ago

2) show me all the machines which were produced from CURRENT DATE to 90 days ago.

Option (2) is my requirement.

Please advice if your proposition will still hold.

Former Member
0 Kudos

Chris,

You can use range for that..

let us knnow if you need more help

Former Member
0 Kudos

As it was said above. When you restrict calendar day change the selection to Value Range.

Select Variables Tab and drag across 0Dat

Right Click and select Variable offset.

In the first window that appears put -90

In the second leave it as 0

It will then do from 90 days ago until today.

HOpe this helps