change date format and then compare dates

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting change date format and then compare dates
# 1  
Old 07-24-2009
Question change date format and then compare dates

I have filenames

My requiremnt needs to extract date which is in MMDDYYand change it into YYYYMMDD format.

I have done the following:
filedate=`echo $filename | awk -F"[_.]" '{print $(NF-2)}'`
formatdate = `echo $filedate | awk 'BEGIN {OFS=""}{print 20 substr($1,5,2), substr($1,1,2), substr($1,3,2)}'`

if [ formatdate -lt myowndate ]

This comparison doesnot work . I have tried putting quotes, < everything nothing works. I understand the problem is formatdate datetype is actually string and so it is not doing the compare.

Is there a way where I can change the MMDDYY date to YYYYMMDD number format . Basically what i need is the YYYYMMDD format to be number datatype . Any solution . I apologise if im not clear.SmilieSmilieSmilieSmilie
# 2  
Old 07-24-2009
to give you a head start
-bash-3.2$ date +"%Y%m%d"
-bash-3.2$ date +"%m%d%y"

# 3  
Old 07-24-2009
hi ryanthegr8,

I cannot use DATE command . I have to extract the date out of the filenames like
071609 and change it to 20090716. Change is not a problem but I need 20090716 in number format. Does it make sense?sorry again if im not clear. And thanks though
# 4  
Old 07-24-2009
try this
-bash-3.2$ file='filenameAGHYSW_fg_050509.tar.gz'
-bash-3.2$ filedate=`echo ${file//[^0-9]/}`
-bash-3.2$ year=`echo $filedate | sed 's|^....||'`
-bash-3.2$ monthday=`echo $filedate |sed 's|..$||g'`
-bash-3.2$ timestamp=`echo "20${year}${monthday}"`
-bash-3.2$ echo $file | sed "s|$filedate|$timestamp|"

# 5  
Old 07-24-2009
Hi RubinPat

you can try this one

fileformatdate=`echo $filename | cut -d "_" -f3 | cut -d "." -f1`
year=20`echo $fileformatdate | cut -c 5-6`
mmday=`echo $fileformatdate | cut -c 1-4`
reqformateddate=`echo $year$mmday`

# 6  
Old 07-24-2009
for fname in $*
    # remove all before last _ including _
    # remove all after first . including .
    if (( yyyymmdd < myowndate )) ; then
        echo "$fname"

using ex.
./thisscript 20081130 filename*_*tar*

---------- Post updated at 10:41 AM ---------- Previous update was at 10:35 AM ----------

your "about" scriptlines include some syntax error.
No space using set value for variable:
formatdate=`echo ...

Using variable, need $
if [ "$formatdate" -lt "$myowndate" ] ; then

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to compare two dates in a specific format ?

Hello, I am not able to find how to compare two dates in '%Y-%m-%d %H:%M:%S,%3N' format i have to two dates as below date1="2016-08-24 09:47:40,444" date2="2016-08-24 10:45:40,567" how to compare these two dates ? I have tried below without success if ; then echo 'yes'; fi ... (6 Replies)
Discussion started by: Ramneekgupta91
6 Replies

2. Shell Programming and Scripting

Change just the date format

need some more help please i have a large file and i want to change just the date format with awk or sed from this yyyy-mm-dd 2016-04-15 8.30 2016-04-15 7.30 2016-04-13 7.30 2016-04-11 8.30 2016-04-11 7.30 2016-04-08 8.30 2016-04-08 7.30 2016-04-06... (5 Replies)
Discussion started by: bob123
5 Replies

3. Shell Programming and Scripting

Compare Date with String in date format

Hi, I am new to this forum, searched, but for some reason did not find much help, so a new thread. I am trying to compare date with a string which is in date format , but for some reason, system does not give me the right result. Date is coming in a file and i am comparing the same with... (2 Replies)
Discussion started by: mkstool
2 Replies

4. Shell Programming and Scripting

ksh compare dates INSIDE a file (ie date A is > date B)

In KSH, I am pasting 2 almost identical files together and each one has a date and time on each line. I need to determine if the first instance of the date/time is greater than the 2nd instance of the date/time. If the first instance is greater, I just need to echo that line. I thought I would... (4 Replies)
Discussion started by: right_coaster
4 Replies

5. Shell Programming and Scripting

awk compare column with date format

I have this code to compare columns 1 and 10 between file1 and file 2 and give me all records that match column 1 but dont match column 10 However column 10 is date format mm/dd/yy and awk cant read it and compare ...i tried awk < file1 -F~ '{print $10}' and it gave blank screen Is... (1 Reply)
Discussion started by: sigh2010
1 Replies

6. UNIX and Linux Applications

sqlite: calculating with dates - compare current date minus 6 months with stored record

Hi I have a table with name, date in format DD.MM.YYYY. I need to something like this (I try to explain in pseudo code) if SYSDATE (current date) minus 6 months > $expiry date print OK else print NOK with $name and $expiry date I know this is possible with Oracle. How to do this... (0 Replies)
Discussion started by: slashdotweenie
0 Replies

7. Solaris

Date after 5 dates in YYYYMMDD format

Hi Experts, How to get date 5 days after current date in YYYYMMDD format? How do we compare date in YYYYMMDD format? Thanks (1 Reply)
Discussion started by: needyourhelp10
1 Replies

8. Shell Programming and Scripting

Date difference between 2 dates in 'yyyy-mm-dd hh:mm:ss' format

Hi all, I know this may have already been asked but hey ho... i have two dates in the 'yyyy-mm-dd hh:mm:ss' format. '2009-01-03 01:00:00' '2009-04-05 00:00:00' How can i, in shell script determine their differences? Please note, the time may not be available, so please suggest both... (4 Replies)
Discussion started by: muay_tb
4 Replies

9. Shell Programming and Scripting

How to Change the Format of a Date

Hi All, this is my second post, last post reply was very helpful. I have a data that has date in DD/MM/YYYY (07/11/2008) format i want to replace the backslash by a dot(.) so that my awk script can read it inside the C shell script that i have written. i want to change 07/11/2008 to... (3 Replies)
Discussion started by: asirohi
3 Replies

10. Shell Programming and Scripting

Compare dates in a field and print the latest date row

Hi, I need a shell script which should find the latest date in the field of file and print that line only. For eg., I have a file /date.log Name Date Status IBM 06/06/07 close DELL 07/27/07 open DELL 06/07/07 open : : : From... (1 Reply)
Discussion started by: cvkishore
1 Replies
Login or Register to Ask a Question