[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

unix k shell script on dates

Posted on 2009-03-31
8
Medium Priority
?
372 Views
Last Modified: 2013-12-26
I need a script in ksh that when I provide a month and year as input let us say JAN-2009 then it should split the dates into weeks and I need to store them as

WEEK1_START = '2009-01-01-00.00.00'
WEEK1_END = '2009-01-09-00.00.00'
WEEK2_START =  '2009-01-09-00.00.00'
WEEK2_END = '2009-01-16-00.00.00'
WEEK3_START ='2009-01-16-00.00.00'
WEEK3_END = '2009-01-23-00.00.00'
WEEK4_START = '2009-01-23-00.00.00'
WEEK4_END =  '2009-02-01-00.00.00'

Let me know how to get this.. I wanted weekly dates in this format since I wanted to use the above values in my db2 script which has datetime as datatype.. Thanks!!
0
Comment
Question by:mahjag
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 84

Expert Comment

by:ozo
ID: 24033703
how do you decide when a week starts and ends?
it looks like your weeks are 8, 9, or 10 days long, and usually start and end on a Friday.
Can you explain the rules for how that works?
0
 

Author Comment

by:mahjag
ID: 24033795
We got this from a customer response and would like to stick with the same dates for any month, let me know if that will be an issue..
0
 
LVL 84

Expert Comment

by:ozo
ID: 24033871
So, always 1st to 9th, 9th to 16th, 16th to 23rd, and 23rd to 1st?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 84

Accepted Solution

by:
ozo earned 500 total points
ID: 24034127
#!/bin/ksh
JAN=01
FEB=02
MAR=03
APR=04
MAY=05
JUN=06
JUL=07
AUG=08
SEP=09
OCT=10
NOV=11
DEC=12
typeset -n mon=${1%-*}
year=${1#*-}
WEEK1_START=$year-${mon}-01-00.00.00
WEEK1_END=$year-${mon}-09-00.00.00
WEEK2_START=$year-${mon}-09-00.00.00
WEEK2_END=$year-${mon}-16-00.00.00
WEEK3_START=$year-${mon}-16-00.00.00
WEEK3_END=$year-${mon}-16-00.00.00
WEEK4_START=$year-${mon}-23-00.00.00
typeset -Z2 e=$(( $mon % 12 + 1 ))
WEEK4_END=$year-${e}-01-00.00.00
0
 

Author Comment

by:mahjag
ID: 24040419
Hi Ozo

I just ran the script above and got error
./weekly_dates.ksh[14]: typeset: bad option(s)
do you know why?
0
 

Author Comment

by:mahjag
ID: 24040516
I looked at man typeset and did not see option for -n
I changed that value to -x and still got syntax errors. Hope I get a solution that is tested, here is the syntax error..
./weekly_dates.ksh[23]:   % 12 + 1 : syntax error - any clues?
0
 

Author Comment

by:mahjag
ID: 24040584
I know this question is closed - but would like to get some response here to complete the task.
0
 
LVL 84

Expert Comment

by:ozo
ID: 24046784
what version of ksh are you running?
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I promised to write further about my project, and here I am.  First, I needed to setup the Primary Server.  You can read how in this article: Setup FreeBSD Server with full HDD encryption (http://www.experts-exchange.com/OS/Unix/BSD/FreeBSD/A_3660-S…
Utilizing an array to gracefully append to a list of EmailAddresses
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
Suggested Courses

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question