awk IF date comparison help


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk IF date comparison help
# 1  
Old 01-06-2020
awk IF date comparison help

Hey everyone,

I'm trying to create a script using awk and if that will list all of our aws tapes that have archived date that is past 90 days from todays current date, so that I can pass that to my aws command to remove.



The fifth column is the creation date in epoch/seconds, so I'm trying to compare that with todays date minus 90 days, in seconds.


Without listing all of my tapes, I'll give a few example lines that aws storagegateway describe-tape-archives spits out

Code:
TAPEARCHIVES     1576094259.759   arn:aws:storagegateway:us-east-2:391499008633:tape/WEEKD02971    WEEKD02971      1575490816.054      2748779069440    ARCHIVED
TAPEARCHIVES     1573055398.804   arn:aws:storagegateway:us-east-2:391499008633:tape/WEEK587EF9    WEEK587EF9      1572283447.825      2748779069440    ARCHIVED

And then here's the command that I'm actually trying to use

Code:
aws  storagegateway describe-tape-archives | awk -v date="$(date +%s)" -v  date1="$(expr $date - 7776000)" '{ if ($5 > $date1) {print}}'

I was also trying this but getting the same results


Code:
aws storagegateway describe-tape-archives | awk -v date="$(date +%s)" '{ if ($5+7776000 < $date) {print}}

This should just return the WEEK587EF9 line, but instead it's returning both lines. I'm a little new to awk so I'm not sure if i have my comparisons messed up, or maybe I should be using another command.

Last edited by Scrutinizer; 01-06-2020 at 02:51 PM.. Reason: Code tags for input sample
# 2  
Old 01-06-2020
Do you want today's nidnight, or the time of the script run, to be the start of the backward time period?
# 3  
Old 01-06-2020
I'd like to end up having this in a cron job that runs daily at midnight.


So i'd like the time of the script run to be the start of the backwards time period.
# 4  
Old 01-06-2020
None of your two archive dates in the second column is older than 90 days as of today (Mo 6. Jan 19:09:41 CET 2020)

Code:
Mi 11. Dez 20:57:39 CET 2019
Mi 6. Nov 16:49:58 CET 2019

# 5  
Old 01-06-2020
*facepalm*


I mistyped that, I'll edit my main post above, I'm actually needing to compare it to the 5th column, which is the tape creation date.
# 6  
Old 01-06-2020
None of your archive dates in the fifth column is older than 90 days
Code:
Mi 4. Dez 21:20:16 CET 2019
Mo 28. Okt 18:24:07 CET 2019

This User Gave Thanks to RudiC For This Post:
# 7  
Old 01-06-2020
Well darn, it's a monday, thanks for catching that.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Date comparison

I have below txt file 02.05.2014 10.05.2014 17.09.2014 My requirement is the user enter date field should compare the input file if user enter date as 12.03.2013 it should compare with all date one by one from input file 12.03.2013 -ne 02.05.2014 12.03.2013 -ne 10.05.2014... (3 Replies)
Discussion started by: stew
3 Replies

2. Shell Programming and Scripting

Date Comparison

Hi Need some function or step to compare the date as given below. Example: Date_1: 25/04/2013 Date_2: 20/07/2012 if Date_1 is greater than Date_2 then do... else do.. fi Need exact unix steps to compare the above condition Use code tags please, see PM. (5 Replies)
Discussion started by: anshaa
5 Replies

3. Shell Programming and Scripting

Date comparison script

hi, I have a file named user.cfg under /var/member/ #user.cfg file under /var/member/ login user: root #how are you login pass: admin #where are you M: user1 pass1 #20121008 M: user2 pass2 #20111230 M: user3 pass3 #20091220 M: user4 pass4 #20070210 M: user5 pass5 #20130708 M:... (3 Replies)
Discussion started by: baris35
3 Replies

4. UNIX for Dummies Questions & Answers

date comparison

Hi friends, I would like to compare two dates in an IF statement. This is what I am trying, but it doesn't work. date=20120122 minus=6 if ; then ... fi what would the IF clause looks like? Thanks! :) (5 Replies)
Discussion started by: kokoro
5 Replies

5. Solaris

Date comparison

Date comparison Hello all I am writing a scrip that will take action so long as the date with in the file is older than 3 months. The file will contain multiple rows of data. Each row will probably start with the date. My question... What is the exact code that should be used for date... (1 Reply)
Discussion started by: UofU
1 Replies

6. Shell Programming and Scripting

Date comparison using ksh

Hi All, i have a text sample below. rootdbs 1 0 01/03/2010.03:11 physdbs 2 0 01/03/2010.03:17 logdbs01 3 0 01/03/2010.03:17 logdbs02 4 0 01/03/2010.03:17 dbs01 5 0 01/03/2010.03:17 dbs02 6 0 01/03/2010.03:17 dbs03 7 0 01/03/2010.03:17 dbs04 ... (4 Replies)
Discussion started by: informix2009
4 Replies

7. Homework & Coursework Questions

Date comparison with 'string date having slashes and time zone' in Bash only

1. The problem statement, all variables and given/known data: I have standard web server log file. It contains different columns (like IP address, request result code, request type etc) including a date column with the format . I have developed a log analysis command line utility that displays... (1 Reply)
Discussion started by: TariqYousaf
1 Replies

8. Shell Programming and Scripting

date comparison in bash

Hi I have this simple script: #!/bin/bash date1=2009:07:15:12:36 date2=2009:07:15:12:16 echo $date1 echo $date2 datediff= #datediff=date1-date2 echo datediff is$datediff How do i return the difference in seconds? (6 Replies)
Discussion started by: carp.dk
6 Replies

9. Shell Programming and Scripting

Date comparison

Hi all, I've a shell script which runs on Bourne shell. I've to do a date comparison. If the value of the supplied parameter(in format YYYYMMDD)is greater than todays's date(format YYYYMMDD), it should prompt the user that the supplied date is greater than today's date. The script is given... (6 Replies)
Discussion started by: sumesh.abraham
6 Replies

10. Shell Programming and Scripting

date comparison

How can I compare two dates in String format (eg. May 23 2006 05:30:21) in AWK? Thanks (2 Replies)
Discussion started by: dkr123
2 Replies
Login or Register to Ask a Question