MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Date calculations

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
coolguy
Beginner


Joined: 01 Dec 2004
Posts: 82
Topics: 28

PostPosted: Tue Mar 06, 2007 9:11 am    Post subject: Date calculations Reply with quote

Hi

I want to calculate some Date funcion


1) I am reading the Date from the file according to the date i want to find out the corresponding Monday and friday

For Ex suppose i got a date 06/Mar/2007 means I need to find out the dates for the Monday and Friday (ie 5th mar 2007 and 9th mar 2007

2) another one case according to the date we need to find out first wroking day of the month and the last working day of the month

working day means monday to friday
my date format is ddmmyy


Pls give me your ideas , it 'll helpful for me

Thanks
Cool
Back to top
View user's profile Send private message
Nic Clouston
Advanced


Joined: 01 Feb 2007
Posts: 1075
Topics: 7
Location: At Home

PostPosted: Tue Mar 06, 2007 9:21 am    Post subject: Reply with quote

The Rexx Date() function will give you the day of week and so will one of the PL/1 date functions. If you are using COBOL then you may be in luck but I do not know - if you are in an LE environment then you may be - I do not know because I am not. I have the source for a PL/1 module which you could convert to cobol if nobody comes up with the answer.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Tue Mar 06, 2007 9:32 am    Post subject: Reply with quote

coolguy,

Search this board for "dayofweek" and you will find many examples.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
coolguy
Beginner


Joined: 01 Dec 2004
Posts: 82
Topics: 28

PostPosted: Wed Mar 07, 2007 12:58 am    Post subject: Reply with quote

Thanks Kolusu , It was rellay help me a lot

Thanks thanks a lot
Cool
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group