Problem to get yesterday's date flatfile with shell script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Problem to get yesterday's date flatfile with shell script
# 1  
Old 10-05-2009
Problem to get yesterday's date flatfile with shell script

hi, i was required to write a shell script to get yesterday's date flatfile. but i only know how to get today's date flatfile. Please observed my below scripting: Please help! Thanks

=================================================
Code:
#!/bin/sh
HOST='192.168.1.200'
USER='ftp1'
PASSWD='1234dfr'
DIR='/rpt/dailyflatfile'
LDIR='/accmgt_inbox'
FILE='p2p'
DATE=`date '+%Y%m%d'`
 
ftp -n $HOST <<END_SCRIPT
quote USER $USER
quote PASS $PASSWD
lcd $LDIR
bin
prompt
mget $FILE$DATE
quit
END_SCRIPT
exit 0

=======================================================

Last edited by Franklin52; 10-05-2009 at 05:24 AM.. Reason: Please use code tags!
# 2  
Old 10-05-2009
do you have GNU date??
# 3  
Old 10-05-2009
Hi, sorry i'm not familiar with shell script, do i need to install it?
Thanks!
# 4  
Old 10-05-2009
To get yesterday date with date:

Code:
date --date="yesterday" '+%Y%m%d'

in your script try:

Code:
DATE=`date --date="yesterday" '+%Y%m%d'`

# 5  
Old 10-05-2009
hi,

try using below code.


Code:
Ydate=`date '+%y:%m:%d' | awk -F":" '{printf"20%2d%2d%2d\n",$1,$2,($3-1)}' | sed 's/ /0/g'`


Last edited by Franklin52; 10-05-2009 at 05:25 AM.. Reason: Please use code tags!
# 6  
Old 10-05-2009
Quote:
Originally Posted by sandeep909
...
Code:
Ydate=`date '+%y:%m:%d' | awk -F":" '{printf"20%2d%2d%2d\n",$1,$2,($3-1)}' | sed 's/ /0/g'`

On the first day of the month it will return 00
# 7  
Old 10-05-2009
Hi Phil,

i had tried your script, however it failed with date error
Thanks!

---------- Post updated at 04:41 PM ---------- Previous update was at 04:35 PM ----------

Hi Sandeep909,

I tried your script, it works well, i managed to mget yesterday's date flatfile.
But is there any exception like On the first day of the month it will return 00
Thanks Bro!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script to compare two files of todays date and yesterday's date

hi all, How to compare two files whether they are same are not...? like i had my input files as 20141201_file.txt and 20141130_file2.txt how to compare the above files based on date .. like todays file and yesterdays file...? (4 Replies)
Discussion started by: hemanthsaikumar
4 Replies

2. Shell Programming and Scripting

How to append date to filename, but base it on yesterday's date?

Hello, I'd like to write a monthly archive script that archives some logs. But I'd like to do it based on yesterday's date. In other words, I'd like to schedule the script to run on the 1st day of each month, but have the archive filename include the previous month instead. Here's what I... (5 Replies)
Discussion started by: nbsparks
5 Replies

3. Shell Programming and Scripting

How to get tomorrow,yesterday date from date Command

Hi I want to get tomorrow and yesterday date from date command. My shell is KSH and server is AIX. I tried several options, but unable to do. Please help on this. Regards Rajesh (5 Replies)
Discussion started by: rajeshmepco
5 Replies

4. Shell Programming and Scripting

[Solved] Replace yesterday date with today's date except from the first line

Hello, I have a file like this: 2012112920121130 12345620121130msABowwiqiq 34477420121129amABamauee e7748420121130ehABeheheei in case the content of the file has the date of yesterday within the lines containing pattern AB this should be replaced by the current date. But if I use... (3 Replies)
Discussion started by: Lilu_CK
3 Replies

5. Shell Programming and Scripting

Need help in Shell Script comparing todays date with Yesterday date from Sysdate

Hi, I want to compare today's date(DDMMYYYY) with yesterday(DDMMYYYY) from system date,if (today month = yesterday month) then execute alter query else do nothing. The above requirement i want in Shell script(KSH)... Can any one please help me? Double post, continued here. (0 Replies)
Discussion started by: kumarmsk1331
0 Replies

6. Shell Programming and Scripting

Getting yesterday's date in shell script

Im in EST, and im using the command CurrentDate=`TZ="EST+24" date +'%y%m%d'` to get the yesterday's date. Does this work perfectly for the boundary conditions of month end or year end(leap year) etc ? (2 Replies)
Discussion started by: prasperl
2 Replies

7. Shell Programming and Scripting

Deleting a line from a flatfile using Shell Script

Hi All, Can Anyone please tell me,how can I delete a line from a file. I am reading the file line by line using whil loop and validating each line..Suppose in the middle i found a particular line is invalid,i need to delete that particular line. Can anyone please help. Thanks in advance,... (14 Replies)
Discussion started by: dinesh1985
14 Replies

8. Shell Programming and Scripting

Compare date from db2 table to yesterday's Unix system date

I am currently running the following Korn shell script which works fine: #!/usr/bin/ksh count=`db2 -x "select count(*) from schema.tablename"` echo "count" I would like to add a "where" clause to the 2nd line that would allow me to get a record count of all the records from schema.tablename... (9 Replies)
Discussion started by: sasaliasim
9 Replies

9. Shell Programming and Scripting

Yesterday date script

Hello All, I am using the below script to get yesterday date, but it is giving date of day before yesterday. Right now its 080906 but this code is giving 080904. And my requirement is 080905. #!/bin/sh CurrentDate=`TZ="GMT+24" date +'%y%m%d'` echo $CurrentDate; WHY? Please help.. ... (7 Replies)
Discussion started by: wakhan
7 Replies

10. Shell Programming and Scripting

yesterday date month/date

Hi expert, I want to retrieve yesterday su log. How to calculate and assign variable value ( 06/23 ) in myVariable ? #!/bin/sh myVariable=yesterday date in month/date cat /var/adm/sulog | grep $myVariable > file.txt many thanks! (5 Replies)
Discussion started by: skully
5 Replies
Login or Register to Ask a Question