Is it possible to get the Weekday of a given date

CJT · Active User Joined: 02 Aug 2007 Posts: 61 Location: blore

Hi,

Is it possible to get the Weekday of a given date?

I know the DATE function gives the weekday value but this works only for the current date. The requirement was to get the weekday for any given past date. Is this possible?

Thanks

enrico-sorichetti · Posted: Fri Sep 28, 2007 1:19 pm Post subject:

Check :
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/IKJ3A320/4.3.16?SHELF=IKJOSE20&DT=20000113164209

regards

e.s

CJT · Active User Joined: 02 Aug 2007 Posts: 61 Location: blore

Hi, thanks for the link. But what i was looking for was something like this

enrico-sorichetti

What about :

wday = date("b",yyyymmdd,"S") // 7

0 = monday
6 = sunday

thats the peculiarity of "base" date

regards

e.s

enrico-sorichetti

Or even better

wday = date("W",yyyymmdd,"S")

regards

e.s

CJT · Active User Joined: 02 Aug 2007 Posts: 61 Location: blore

thanks a million buddy.

this worked for me perfectly fine!