Sponsored Content
Top Forums Shell Programming and Scripting Grep search for value between dates Post 302737203 by Yoda on Wednesday 28th of November 2012 01:09:43 PM
Old 11-28-2012
Code:
#!/bin/bash

CURR_DATE=$( date +"%s" )
PREV_DATE=$( date -d"2012-02-17" +"%s" )                

extr_xmld=$( awk -F"Value=" '/TNT_License_End/ { gsub("\"","",$2); print $2; } ' xml_file )
XMLF_DATE=$( date -d"$extr_xmld" +"%s" )

if [ ${XMLF_DATE} -ge ${PREV_DATE} ] && [ ${XMLF_DATE} -le ${CURR_DATE} ]
then
        echo "Is between Feb 17 & Today"
else
        echo "Is not between Feb 17 & Today"
fi

 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

grep a log file between 2 dates

Hi Currently I can grep a log file with the following command: $results = `grep -A 2 '^$date.$time.*' $log`; and the following arguments: $date = 2007/04/25 $time = 16:07 Log example: 2007/04/25 16:07:12.145701 2007/05/25 14:07:12.145701 2007/05/25 17:07:12.145701 2007/06/25... (37 Replies)
Discussion started by: Epiphone
37 Replies

2. Shell Programming and Scripting

grep a log file to filter previous dates

Hi, I have problem of filtering a log file from my perl script. #cat /data/pinpe.csv_20070731 | nawk -v FS=, '{print $1','$18','$22','$26}' | grep -w 100 | grep -w 1 | nawk '{print $4}' Below is the output: 2009-06-16 2009-01-29 2009-06-02 2008-03-05 2007-08-05 2007-09-24... (5 Replies)
Discussion started by: pinpe
5 Replies

3. UNIX for Dummies Questions & Answers

How do I search between dates?

I have a folder that has files that go way back to 2005. How can I search for files between say Jan 2006 - Dec 2007 only? I did a man on the Find command but nothing in there. Any help would be appreciated. (4 Replies)
Discussion started by: bbbngowc
4 Replies

4. Shell Programming and Scripting

Need script to generate all the dates in DDMMYY format between 2 dates

Hello friends, I am looking for a script or method that can display all the dates between any 2 given dates. Input: Date 1 290109 Date 2 010209 Output: 300109 310109 Please help me. Thanks. :):confused: (2 Replies)
Discussion started by: frozensmilz
2 Replies

5. Shell Programming and Scripting

Script to search specific folders dates /mm/dd/ structure

Hi, I have a script that handles a huge amount of log files from many machines and copies it into a SAN location with the following directory structure: /SAN/machinenames/yyyy/m/d so for example /SAN/hosta/2011/3/12/files* Now I am writing a bash script to search for files between to date... (4 Replies)
Discussion started by: GermanJulian
4 Replies

6. Shell Programming and Scripting

Search pattern on logfile and search for day/dates and skip duplicate lines if any

Hi, I've written a script to search for an Oracle ORA- error on a log file, print that line and the .trc file associated with it as well as the dateline of when I assumed the error occured. In most it is the first dateline previous to the error. Unfortunately, this is not a fool proof script.... (2 Replies)
Discussion started by: newbie_01
2 Replies

7. Programming

MYSQL query search between dates

Just a little help if possible I have a table with date data, I want to select dates that fall between today and 1 month ago, here's my query SELECT id, stdate, DATE_SUB(CURDATE(), INTERVAL 1 month) as monthago, CURDATE() as today FROM data_table where (stdate between 'today' and 'monthago')... (4 Replies)
Discussion started by: barrydocks
4 Replies

8. What is on Your Mind?

Grep file containing dates

How to grep a file containing dates to only last 30 days then move to another folder (7 Replies)
Discussion started by: kmarcus
7 Replies

9. UNIX for Beginners Questions & Answers

How to use a grep search to search for a specific string within multiple directories?

Lets say I have a massive directory which is filled with other directories all filled with different c++ scripts and I want a listing of all the scripts that contain the string: "this string". Is there a way to use a grep search for that? I tried: grep -lr "this string" * but I do not... (3 Replies)
Discussion started by: Circuits
3 Replies
PX_DATE2STRING(3)														 PX_DATE2STRING(3)

px_date2string - Converts a date into a string.

SYNOPSIS
string px_date2string (resource $pxdoc, int $value, string $format) DESCRIPTION
Turns a date as it stored in the paradox file into human readable format. Paradox dates are the number of days since 1.1.0000. This func- tion is just for convenience. It can be easily replaced by some math and the calendar functions as demonstrated in the example below. PARAMETERS
o $pxdoc - Resource identifier of the paradox database as returned by px_new(3). o $value - Value as stored in paradox database field of type PX_FIELD_DATE. o $format - String format similar to the format used by date(3). The placeholders support by this function is a subset of those supported by date(3) (Y, y, m, n, d, j, L). RETURN VALUES
Returns TRUE on success or FALSE on failure. EXAMPLES
Example #1 Turn a paradox date into a human readable form <?php $px = px_new(); /* make up a date as it could be stored in */ /* a date field of a paradox db. */ /* 700000 days since 1.1.0000. */ $days = 700000; /* Use the calendar functions to print a */ /* human readable format of the date */ echo jdtogregorian($days+1721425)." "; /* px_date2string() outputs the same */ echo px_date2string($px, $days, "n/d/Y")." "; px_delete($px); ?> The above example will output: 7/15/1917 7/15/1917 SEE ALSO
px_timestamp2string(3), jdtogregorian(3). PHP Documentation Group PX_DATE2STRING(3)
All times are GMT -4. The time now is 02:46 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy