Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Date increment

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Date increment
# 1  
Old 05-03-2010
Date increment
hi Friends,


Code:
Today_Dt=`date "+%Y-%m-%d"`


So the Today date is 2010-05-03

I have a file which has date values as below

Code:
2010-04-27
2010-04-02
2010-04-18
2010-04-28
2010-04-29
..


I need find out latest date from the file and I want to add all the dates that resides between latest date and today date. Atlast I should add today date also in the file.


So the output file should be like
Code:
2010-04-02
2010-04-18
2010-04-27
2010-04-28
2010-04-29
2010-04-30
2010-05-01
2010-05-02
2010-05-03


any idea friends ?
Last edited by Scott; 05-03-2010 at 07:23 AM.. Reason: Fixed CODE TAGS - [code], not <code>
# 2  
Old 05-03-2010
Take a look at this thread Yesterdays Date/Date Arithmetic

Jean-Pierre.

---------- Post updated at 14:11 ---------- Previous update was at 13:47 ----------

A solution using datecalc :
Code:
#!/usr/bin/ksh

dateFile=gopal.txt

jLast=$( datecalc -j $( sed -n '$s/-/ /gp' ${dateFile} ) )
jToday=$( datecalc -j $( date +'%Y %m %d' ) )

while (( jLast < jToday ))
do
   (( jLast += 1 ))
   printf "%4d-%02d-%02d\n" $(datecalc -j ${jLast})
done >> ${dateFile}

Input file:
Code:
2010-04-27
2010-04-02
2010-04-18
2010-04-28
2010-04-29

Output file:
Code:
2010-04-27
2010-04-02
2010-04-18
2010-04-28
2010-04-29
2010-04-30
2010-05-01
2010-05-02
2010-05-03

Jean-Pierre.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Urgent for date increment

hi all, i would like to increment the date variable i am using for((i=20190731;i<=20190801;i++)) do done after 20190731 it should be 20190801 but this taking as 20190732,20190733.... kindly help me to solve this (3 Replies)
Discussion started by: prathaban
3 Replies

2. Shell Programming and Scripting

Increment date variable

hey guys, I need to incerement the date variable for instance echo `date '+%F %H:%M:00'` this produces 2014-08-02 20:05:00 -I will grant this to : $Datehour and need to assign 1 hr from now to $Datelasthour -the script time will be used to talk to DB system information. however... (4 Replies)
Discussion started by: mo_VERTICASQL
4 Replies

3. Shell Programming and Scripting

Date increment logic

Hi all, I need to increment date at run time. Example: I need to write a shell script with two parameters. 1. country code like (US,UK, IND.....) 2. Date range from_date to to_date (20070101 to 20070331) I need to run shell script like this country_info.sh US 20070101 20070331 ... (3 Replies)
Discussion started by: pmreddy
3 Replies

4. Shell Programming and Scripting

how to update date part with new increment date time

hi experts, my requirement is like this i need to develop a shell script to update date part with new incremental date time in file some 'X' which is kept at some server location incrementing every two hours.as i am new to this scripting i need support from u people,thanx in advance (1 Reply)
Discussion started by: amanmro
1 Replies

5. Shell Programming and Scripting

Increment in date

Hi, I have a variable lets say DATA_DATE. I have to pass some value to this variable in YYYYMMDD format. lets say today I have passed this variable as : DATA_DATE=20100107 Then pls help me how to calculate another variable DATA_DATE1 (which is DATA_DATE+1). The code should work... (3 Replies)
Discussion started by: 46019
3 Replies

6. Shell Programming and Scripting

Increment date in script

Hi, Iam new to scripting language.:o can someone help me out solving this thread?hopingly ya....:) I want to write a script which connects to db and searches the count in a table which has date column and id column. If the count is not equal to 0 then it should increment the date with the one... (4 Replies)
Discussion started by: jyothi_wipro
4 Replies

7. Shell Programming and Scripting

How to increment a user defined date value in the DATE format itself using shell script?

I need to increment a date value through shell script. Input value consist of start date and end date in DATE format of unix. For eg. I need increment a date value of 1/1/09 to 31/12/09 i.e for a whole yr. The output must look like 1/1/09 2/2/09 . . . 31/1/09 . . 1/2/09 . 28/2/09... (1 Reply)
Discussion started by: sunil087
1 Replies

8. Shell Programming and Scripting

Can we increment or decrement a date value?

export a=`date` a=`expr $a + 1` Is it possible? if not how can i increment or decrement a date variable? (2 Replies)
Discussion started by: arghya_owen
2 Replies

9. Shell Programming and Scripting

Shell Script To increment Date*HElp***

Hi, I want to increment date, using Shell Script, a loop to add one day after 24hrs. :confused: Cheers Kunal (1 Reply)
Discussion started by: niceboykunal123
1 Replies

10. Shell Programming and Scripting

Increment date in 'for' loop?

Hi Guys, My first post..:) Right...I want to move existing files (with some date in their name) currently in $mainftp, to $mainfolder/$foldate/system1. I'd like to be able to increment date in the for loop? Is this possible or should I use a different technique. The script return the... (4 Replies)
Discussion started by: SunnyK
4 Replies
Login or Register to Ask a Question