Getting yesterday DATE


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Getting yesterday DATE
# 15  
Old 04-24-2008
Quote:
Originally Posted by djsal
I needed that functionality once too, I went about it by appending the current date to a file every day at 23:59 in cron... then refrencing that file whenever I needed to write a script to get things for yesterday... or last 5 days and so on and so forth.

yesterdaysdate=`head -1 $datefile`
past5days=`head -5 $datefile`
I do something similar. I put the date into a file, but I rename the files to age them. I.E.:
Code:
mv day29 day30
mv day28 day29
...
mv day01 day02
date +%D > day_01

One other thing I do is run it at around 11:00am Mon to Fri, and I first check to see if there are at least 'x' users logged in. 'x' is 70% of my typical number of users. This way my dates only contain business dates, and automatically skip holidays and snow days.

When using them, I always selected TWO day files. I.E. check to see if my date is <= day06 and > day07, or something similar.
# 16  
Old 06-06-2008
Getting yesterday's date using expr

This has bothered me for a while and I think I finally found a real solution in Solaris using the expr command to do the math for you.

you have to find today's date and put it in a variable.
Code:
today=`date +%Y%m%d`

Then run the expr command to get yesterday's date or two days ago, etc.
Code:
yesterday=`expr $today - 1`
echo $yesterday

This should work or does at least in Solaris 10.

Last edited by Yogesh Sawant; 09-25-2009 at 03:21 AM.. Reason: added code tags
# 17  
Old 06-06-2008
Quote:
Originally Posted by mbrown7776
This has bothered me for a while and I think I finally found a real solution in Solaris using the expr command to do the math for you.

you have to find today's date and put it in a variable.

today=`date +%Y%m%d`

Then run the expr command to get yesterday's date or two days ago, etc.

yesterday=`expr $today - 1`
echo $yesterday

This should work or does at least in Solaris 10.
Will not work in general. On January 1 your technique will report that yesterday was January 0.
# 18  
Old 06-24-2009
MySQL TZ is the Time Zone Shell Parameter

The clever shell scripter is using an undocumented feature of the time zone command. It worked for +48 and -168 when I tested, but adding a semicolon to end the command ruins it. The CST is "Central Standard Time".
# 19  
Old 09-23-2009
yesterday's working day

Yesterday's working day

RE: Shell script problem for you...
Code:
((D=$(date +%w)+2))
if [ $D -gt 3 ]; then D=1; fi
YESTERDAY=`TZ="GMT+$((D*24))" date  +%Y%m%d`; echo $YESTERDAY


Last edited by Yogesh Sawant; 12-14-2009 at 01:22 AM.. Reason: added code tags
# 20  
Old 09-23-2009
I usually compute:
Code:
$date --date="yesterday"

works with tomorrow too.

Last edited by Yogesh Sawant; 09-25-2009 at 03:22 AM.. Reason: added code tags
# 21  
Old 12-11-2009
hello from Brazil! My english is not good but i will try...
Im a Ubuntu user and i got yesterday's date like this

(for yesterday)
date -d yesterday

(for 2 days ago)
date -d 2yesterday

you add days before the word "yesterday" and get how many days ago u want,

(for 100 days ago)
date -d 100yesterday

u can put the output format u want, as
date -d 1000yesterday +%Y-%m-%d-%Hh%M

and also u can do the same for next days, using "tomorrow"
date -d 1000tomorrow +%Y-%m-%d-%Hh%M
This User Gave Thanks to lalla_br For This Post:
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

yesterday's date

curdate=$(date +"%d-%b-%y") How to get the yesterday's date. (1 Reply)
Discussion started by: sandy1028
1 Replies

7. Shell Programming and Scripting

yesterday's date

I was playing to find a simple way to get yesterday's date, and came up with this (on an AIX 5.2 box): $ date Thu Feb 19 11:21:26 EST 2009 $ echo $TZ EST5EDT $ yesterday=`TZ=$(date +%Z)+24 date` $ echo $yesterday Wed Feb 18 16:21:52 GMT 2009 Why it is converted to GMT instead of... (2 Replies)
Discussion started by: gratus
2 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 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

10. Shell Programming and Scripting

get yesterday's date?

Hello, using date, we can easily get today's date $ date +%y-%m-%d 06-12-08 is it possible for me to get yesterday's date using 'date', if not, is there any quick and easy way to do that? Thanks! (1 Reply)
Discussion started by: fedora
1 Replies
Login or Register to Ask a Question