Re: Check date range

No, you just need to make an IF statement comparing against the two dates.


Michael Schutte
Admin Professional
Bob Evans Farms, Inc.
"The Secret's the Sauce! Enjoy our new Bob-B-Q Pulled Pork Knife & Fork
Sandwich!"




"derek gonsalves"
<d_gons@xxxxxxxxx
om> To
Sent by: RPG400-L@xxxxxxxxxxxx
rpg400-l-bounces@ cc
midrange.com
Subject
Check date range
07/24/2007 10:13
AM


Please respond to
RPG programming
on the AS400 /
iSeries
<rpg400-l@midrang
e.com>







Hello everyone,

Is there any Op-code for date Range?
I have a date field which is 7,0 in length - 1072207
(Century/month/day/year)
The requirement is as follows -
I need to enter a rate for a particular period for a product.

Perid

From To Product

07//16/07 08/16/07 ABC

Now i need to perform validations to make sure that the next date range
entry for that product does not exist.

Thus -
07/23/07 to 08/23/07 should not be allowed , since we already have a rate

for that product in that period(rate for the same product should be
allowed
as long as they reference disjoint periods)

Is there any opcode which i can use for checking the range OR any other
suggestion?

Thanks in advance
Derek