How to check a date is falling in between two given dates

sm_2009 · New User Joined: 10 May 2009 Posts: 72 Location: bangalore

hi

i need to check input date in file is falling between two given dates.

pls suggest

thanks

dbzTHEdinosauer · Posted: Wed May 20, 2009 7:10 pm

NOTEB: Between means inclusive of lower and higher value.

If input-date GTEQ lower-given-date
and input-date LTEQ higher-given-date
then
the input-date falls between the two given dates.

sm_2009 · New User Joined: 10 May 2009 Posts: 72 Location: bangalore

wht is the format you suggest?

all dates are pic x(10) yyyy-mm-dd
will it work this format?

pls suggest

star_dhruv2000 · Posted: Fri May 22, 2009 11:53 pm

Try convert dates in integer and compre them. Use DATE-OF-INTEGER and INTEGER-OF-DATE functions.

Basic date format in INTEGER-OF-DATE is CCYYMMDD.

Happy coding !!!
Cheers

dick scherrer · Posted: Sat May 23, 2009 12:15 am

Hello,

I must be missing something. . .