date issue-find prevoius date in a patricular format


 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users date issue-find prevoius date in a patricular format
# 1  
Old 11-15-2007
date issue-find prevoius date in a patricular format

Hi ,

I have written a shell script that takes the current date on the server and stores it in a file.

echo get /usr/home/data-`date '+%Y%d'`.xml> /usr/local/sandeep/GetFILE.ini

I call this GetFILE.ini file from an sftp program to fetch a file from /usr/home/ as location. The file is in this format data-20071115.xml
I have been succesfull in doing this.

This runs froms tuesday to friday. But on Monday i need to fetch Saturday and Sunday file and i don't know how it can be accomplished in this.

Can anyone help

Thanks,
Sandeep
# 2  
Old 11-15-2007
The datecalc script in Perderabo's thread on Date Arithmetic - in the FAQ section
will subtract 1, 2, 3... n days from a date and return a date. So you could get
today - 2 = 20071113
# 3  
Old 11-15-2007
Quote:
Originally Posted by bsandeep_80
Hi ,

I have written a shell script that takes the current date on the server and stores it in a file.

echo get /usr/home/data-`date '+%Y%d'`.xml> /usr/local/sandeep/GetFILE.ini

I call this GetFILE.ini file from an sftp program to fetch a file from /usr/home/ as location. The file is in this format data-20071115.xml
I have been succesfull in doing this.

This runs froms tuesday to friday. But on Monday i need to fetch Saturday and Sunday file and i don't know how it can be accomplished in this.

Can anyone help

Thanks,
Sandeep
This relies on GNU date.
Code:
#!/bin/bash
if [[ $(date +%u) = 1 ]]
then
  echo get /usr/home/data-$(date --date="-2 days" '+%Y%m%d').xml > /usr/local/sandeep/GetFILE.ini
  # some command that calls GetFILE.ini, before it is overwritten.
  echo get /usr/home/data-$(date --date="-1 days" '+%Y%m%d').xml > /usr/local/sandeep/GetFILE.ini
else
  echo get /usr/home/data-$(date '+%Y%m%d').xml > /usr/local/sandeep/GetFILE.ini
fi

# 4  
Old 11-15-2007
You'll find help to this same query in a simple search too.
Key words: previous date

Cheers,
Cameron
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Date: invalid date trying to set Linux date in specific format

i try to set linux date & time in specific format but it keep giving me error Example : date "+%d-%m-%C%y %H:%M:%S" -d "19-01-2017 00:05:01" or date +"%d-%m-%C%y %H:%M:%S" -d "19-01-2017 00:05:01" keep giving me this error : date: invalid date ‘19-01-2017 00:05:01' Please use CODE tags... (7 Replies)
Discussion started by: umen
7 Replies

2. Solaris

Solaris 5.8 Upgrade is causing Date format issue.

Hi I have a JAVA based application in development and production environment. These two environments are exactly identical in terms of OS, hardware and application components. Initially the OS was Solaris 5.6 and the application was working fine in both environments. But later when the OS... (12 Replies)
Discussion started by: Jayant Tripathi
12 Replies

3. UNIX for Dummies Questions & Answers

Rename all Files in a UNIX Directory from one date format to another date format

Hi Unix Gurus, I would like to rename several files in a Unix Directory . The filenames can have more than 1 underscore ( _ ) and the last underscore is always followed by a date in the format mmddyyyy. The Extension of the files can be .txt or .pdf or .xls etc and is case insensitive ie... (1 Reply)
Discussion started by: pchegoor
1 Replies

4. UNIX for Dummies Questions & Answers

How to find the date format

I have a requirement where the user send a file. If the file is empty they put datetimestamp(YYYYMMDDHH:MM:SS) otherwise they would be data. I can do cat and get whats in file but how can I see if the data is date timestamp. In short, if format(data in file) = YYYYMMDDHH:MM:SS then... (13 Replies)
Discussion started by: eskay
13 Replies

5. Shell Programming and Scripting

to replace Date format issue

Hi, I have the below data in a file in one of the path, 101 02100002111406893401207310900A094101xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 5200xxxxxxxxxx D18000_1 CCDXXXXXXX JUL 31201207 1140689340000001 622113010547999999999003 000333333334RE ... (1 Reply)
Discussion started by: Ramyajiguru1
1 Replies

6. Shell Programming and Scripting

finding date numeral from file and check the validity of date format

hi there I have file names in different format as below triss_20111117_fxcb.csv triss_fxcb_20111117.csv xpnl_hypo_reu_miplvdone_11172011.csv xpnl_hypo_reu_miplvdone_11-17-2011.csv xpnl_hypo_reu_miplvdone_20111117.csv xpnl_hypo_reu_miplvdone_20111117xfb.csv... (10 Replies)
Discussion started by: manas_ranjan
10 Replies

7. UNIX for Dummies Questions & Answers

Shell Scripts - shows today’s date and time in a better format than ‘date’ (Uses positional paramete

Hello, I am trying to show today's date and time in a better format than ‘date' (Using positional parameters). I found a command mktime and am wondering if this is the best command to use or will this also show me the time elapse since 1/30/70? Any help would be greatly appreciated, Thanks... (3 Replies)
Discussion started by: citizencro
3 Replies

8. 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

9. UNIX for Dummies Questions & Answers

Changing from Excel date format to MySQL date format

I have a list of dates in the following format: mm/dd/yyyy and want to change these to the MySQL standard format: yyyy-mm-dd. The dates in the original file may or may not be zero padded, so April is sometimes "04" and other times simply "4". This is what I use to change the format: sed -i '' -e... (2 Replies)
Discussion started by: figaro
2 Replies

10. Shell Programming and Scripting

convert date format to mysql date format in log file

I have a comma delimited log file which has the date as MM/DD/YY in the 2nd column, and HH:MM:SS in the 3rd column. I need to change the date format to YYYY-MM-DD and merge it with the the time HH:MM:SS. How will I got about this? Sample input 02/27/09,23:52:31 02/27/09,23:52:52... (3 Replies)
Discussion started by: hazno
3 Replies
Login or Register to Ask a Question