Date validation

Rajkumar_n · Posted: Wed Jun 09, 2010 11:54 am

Hi,

I have a requirement where I need to prepare extract conditionally.

I have a column A which is a date field and defined as CHAR, We need to validate this column to check the day of this column field should be in beween Monday and Firday.

Is there a way to check this condition. If this topic is already discussed then please let me know the link of the post where it was discussed.

Thanks and Regards,
Rajkumar Nerella

enrico-sorichetti · Posted: Wed Jun 09, 2010 12:43 pm

all depends on the format of the <date> field

for the format of things that can be processed by the DATE function

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQK15/2.10.7.5?SHELF=DSNSHKA3&DT=20081120084907#HDRWQ11363

for the DATE function
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQK15/3.2.26?SHELF=DSNSHKA3&DT=20081120084907

for the DAYOFWEEK and DAYOFWEEK_ISO functions
( the second has a more friendly numbering scheme MON = 1 .... SUN = 7)
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQK15/3.2.30?SHELF=DSNSHKA3&DT=20081120084907

and try to use something along the lines of

DAYOFWEEK_ISO(DATE(<yourcolunnname>)) BETWEEN 1 AND 6

( hint not tested )

Rajkumar_n · Posted: Wed Jun 09, 2010 2:29 pm

It Helped me a lot.

Thanks a lot for your help.

Thanks and Regards,
Rajkumar Nerella