Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Convert string to date and add 20 days

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Convert string to date and add 20 days
# 1  
Old 11-30-2016
Convert string to date and add 20 days
Hi,

I have a requirement where I am getting date in string format (20161130). I need to add 20 days(not no. 20) to the above string. The o/p should 20161220.

In case of 20170228, it should show 20170320.

Could you please help me with the command to achieve this.

Note: I am using AIX 7.1 environment.

Thanks in advance.
Satya
# 2  
Old 11-30-2016
Hello satyaatcgi,

If you have GNU date in your system then following may help you in same.
Code:
date -d"20161130 +20 days"

Thanks,
R. Singh
# 3  
Old 11-30-2016
Thanks Ravinder. but I am getting the below error.

Code:
date: illegal option -- d
Usage: date [-u] [+Field Descriptors]
bash-4.3$

Last edited by rbatte1; 11-30-2016 at 10:10 AM.. Reason: Added CODE tags for output/errors
# 4  
Old 11-30-2016
Being AIX, you will probably need to convert to seconds, add 1728000 (20x24x60x60) and then convert back.

Perl can help you do this, but there may be better ways, especially if you have lots of input to loop around. Can you tell us a little more about the overall process?



Robin
# 5  
Old 12-01-2016
Hi,

I am receiving a file with last day of the month in the filename. Ex: SRC_YYYYMMDD.DAT (SRC_20161031.DAT) and while I will generate my target file after processing the source file, it should add 20 days to the date mentioned in the file name and generate the target file as TGT_YYYYMMDD.DAT (TGT_20161120.DAT) .

Hope you got this requirement.
# 6  
Old 12-01-2016
Hi.

For a system like:
Code:
aix 7.1.0.0
perl 5.10.1
date.pl - ( local: RepRev 1.13, ~/bin/date.pl, Dec 01 23:15 )

this:
Code:
$ date.pl -d "20161130 +20 days"

produced this:
Code:
2016-12-20 00:00:00

Some details:
Code:
date.pl  GNU date work-alike. (what)
Path    : ~/bin/date.pl
Version : - ( local: RepRev 1.13, ~/bin/date.pl, 2016-09-11 )
Length  : 378 lines
Type    : Perl script, ASCII text executable
Shebang : #!/usr/bin/env perl
Help    : probably available with --help
Modules : (for perl codes)
 POSIX  1.38_03
 strict 1.08
 warnings       1.23
 constant       1.31

See https://www.unix.com/tips-tutorials/2...te-script.html : for the perl code for date.pl and if it works for you send a thank you to Corona688

Best wishes ... cheers, drl
This User Gave Thanks to drl For This Post:
rbatte1
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert string to date and add 1 hours

i have some set of date data inside csv files and need to convert the timezone, 08302016113611861 08302016113623442 08302016113541570 08302016113557732 08302016113548439 08302016112853115 08302016113620684 08302016113432827 08302016113630321 date format is : %m%d%Y%H%M%Smilisec ... (2 Replies)
Discussion started by: before4
2 Replies

2. Shell Programming and Scripting

Convert date into days using shell script

Hi, I have date format in an excel sheet as 07/03/2014 11:21. I need to check this date with current date and need to find whether it is more than 30 days or not. I know how to current date into days, but someone please help me to change the date in the excel sheet to days, so that i can check... (2 Replies)
Discussion started by: Arasu123
2 Replies

3. Shell Programming and Scripting

Convert string into date format

Hi, I am getting the below string as a input for date. 12/03/2013 11:02 AM I want to change this date as 03-DEC-2013 11:02 AM. Could you please help on this. Thanks Chelladurai (4 Replies)
Discussion started by: ckchelladurai
4 Replies

4. Shell Programming and Scripting

Please help me days to a date string in PERL

Please help me n days to a date string in PERL. Date is of the format YYYYMMDD ---------- Post updated at 08:56 AM ---------- Previous update was at 08:54 AM ---------- Add n days (2 Replies)
Discussion started by: yahoo
2 Replies

5. Emergency UNIX and Linux Support

Convert string to date and add 1

Hi All, I want to convert string in format YYYYMMDD(20120607) to date in unix and add 1 day to it and convert back to string in format YYYYMMDD. Please help. (4 Replies)
Discussion started by: cns1710
4 Replies

6. AIX

Convert string to date in script

Hi, How can I convert a string "Jul 10 09" to date in aix? the output can be like 20090710. Thanks. (4 Replies)
Discussion started by: Gbyte
4 Replies

7. Shell Programming and Scripting

Convert String to Date Unix

Hi people, I need to convert a string eg 09/13/2008 to a valid unix date. (4 Replies)
Discussion started by: sameerspice
4 Replies

8. Shell Programming and Scripting

Convert String to Date

Hi, I have a String input parameter like this: 20080430 (YYYYMMDD). Inside my korn shell script I need to add one day to this date. L_TRADE_DAY=$1 let L_TODAY=$L_TRADE_DAY+1 Offcourse this raises a problem at the end of a month. 20080430 + 1 gives 20080431 instead of 20080501. ... (2 Replies)
Discussion started by: ORatjeuh
2 Replies

9. Shell Programming and Scripting

Convert DATE string to a formatted text

Hi guys, i need your help. I need to convert a date like this one 20071003071023 , to a formated date like 20071003 07:10:23 . Could this be possible ? Regards, Osramos (6 Replies)
Discussion started by: osramos
6 Replies
Login or Register to Ask a Question