Get number of days between given dates


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Get number of days between given dates
# 1  
Old 04-24-2010
Get number of days between given dates

Hi

I need one single command to get number of days between
two given dates.datecalc is not working.

ex.
fromdate:01.04.2010
todate :24.04.2010

i should get the out put as 23

Thanks in advance
# 2  
Old 04-24-2010
With the datecalc script of Perderabo https://www.unix.com/unix-dummies-que...html#post16559 you should get the desired output but the date must be reformatted:
Code:
#!/bin/sh

fromdate=01.04.2010
todate=24.04.2010

from=`echo $fromdate | awk  -F\. '{print $3 OFS $2 OFS $1}'`
to=`echo $todate | awk  -F\. '{print $3 OFS $2 OFS $1}'`

./datecalc -a $to - $from

# 3  
Old 04-24-2010
Here is a slightly modified example based on the above.
First we reformat the date to YYYYMMDD format.
Then for each date we compute the number of seconds since 1970-01-01 00:00:00 UTC (parameter %s of the date function)
Finally the result is divided by 86400 (number of seconds in a day).

Code:
#!/bin/sh

fromdate=01.04.2010
todate=24.04.2010

from=`echo $fromdate | awk  -F\. '{print $3$2$1}'`
to=`echo $todate | awk  -F\. '{print $3$2$1}'`

START_DATE=`date --date=$from +"%s"`
END_DATE=`date --date=$to +"%s"`

DAYS=$((($END_DATE - $START_DATE) / 86400 ))
echo $DAYS

=> 23
# 4  
Old 04-24-2010
Quote:
Originally Posted by BigBro
Here is a slightly modified example based on the above.
First we reformat the date to YYYYMMDD format.
Then for each date we compute the number of seconds since 1970-01-01 00:00:00 UTC (parameter %s of the date function)
Finally the result is divided by 86400 (number of seconds in a day).

Code:
#!/bin/sh

fromdate=01.04.2010
todate=24.04.2010

from=`echo $fromdate | awk  -F\. '{print $3$2$1}'`
to=`echo $todate | awk  -F\. '{print $3$2$1}'`

START_DATE=`date --date=$from +"%s"`
END_DATE=`date --date=$to +"%s"`

DAYS=$((($END_DATE - $START_DATE) / 86400 ))
echo $DAYS

=> 23
--date is an option of the GNU date and is not portable.
# 5  
Old 04-25-2010
Using ks93 printf properties:
Code:
#!/bin/ksh
isodate()
{      # dd.mm.yyyy to yyyy-mm-dd
        indate="$1"
        oifs="$IFS"
        IFS="."
        values=($indate)
        IFS="$oifs"
        iso="${values[2]}-${values[1]}-${values[0]}"
        echo "$iso"
}

fromdate=$(isodate 01.04.2010)
todate=$(isodate 24.04.2010)
# datestr => epoc
epoc1=$(printf "%(%#)T"   "$fromdate")
epoc2=$(printf "%(%#)T"   "$todate")

# length of day (seconds) = 86400
((day=24*60*60))
echo $(( (epoc2-epoc1) /day))

More datecalc examples in my answer, and all other answers

Last edited by kshji; 04-25-2010 at 09:49 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Get number of days between 2 dates

Gents. Please can u help. I would like to calculate the days between two dates. Example file1 ( previous date) file1 - Input file 9/29/2010 10195 9/29/2010 1057 2/2/2016 10 2/2/2016 10169 2/2/2016 1057 2/3/2016 10005 2/3/2016 10014 In file2 I add the actual date using this code.... (9 Replies)
Discussion started by: jiam912
9 Replies

2. UNIX for Advanced & Expert Users

How to get the sunday days between two dates?

Hi Am using Unix Ksh I have a two date input as DATE1=02/12/2012 DATE2=30/12/2012 I Need the output as only sunday date 02/12/2012 09/12/2012 16/12/2012 23/12/2012 30/12/2012 can anyone pls help me.. thanks in advance... (2 Replies)
Discussion started by: Venkatesh1
2 Replies

3. Shell Programming and Scripting

Calculate the number of days between 2 dates - bash script

I wrote the day calculator also in bash. I would like to now, that is it good so? #!/bin/bash datum1=`date -d "1991/1/1" "+%s"` datum2=`date "+%s"` diff=$(($datum2-$datum1)) days=$(($diff/(60*60*24))) echo $days Thanks in advance for your help! (3 Replies)
Discussion started by: kovacsakos
3 Replies

4. Web Development

Calculate the number of days between 2 dates - PHP

Is this code good for this purpose? <?php $date1 = mktime(0,0,0,01,01,1991); $date2 = mktime(0,0,0,03,22,2012); $diff = $date2 - $date1; $days = $diff / (60*60*24); echo ($days . "<br />"); ?> (3 Replies)
Discussion started by: kovacsakos
3 Replies

5. Shell Programming and Scripting

days are between the two dates?

I have two times in the format of YYMMDD. Does anyone know an easy way in ksh for me to display how many days are between the two dates? Example1: X=101202 Y=101205 There are 3 days between X & Y Example2: X=101202 Y=111202 There are 365 days between X & Y Example3: X=101205... (3 Replies)
Discussion started by: oldman2
3 Replies

6. Shell Programming and Scripting

Days difference between two dates

Hello, I would like to find out the number of days between two dates of the format yyyy-mm-dd. Any help on this is highly appreciated. Thanks. (6 Replies)
Discussion started by: Data469
6 Replies

7. UNIX for Advanced & Expert Users

Number of days between two distinct dates

Hi I'm looking for a .ksh script/function that will calculate ONLY the number of days between two distinct dates. Further convert the number of days to weeks and display. I need this to be part of another larger script that checks the password expiry on several servers and notifies the... (1 Reply)
Discussion started by: radheymohan
1 Replies

8. Shell Programming and Scripting

Find number of days and list out the dates in between

Hi All, Can unix cshell list out the number of days between 070201 and 070205 (format is yymmdd) and list out all the dates in between in similiar format. set startdate = `date '+%y%m%d'` #eg 070201 set enddate = `date '+%y%m%d'` #eg 070205 i would expect the number of days to be 5... (2 Replies)
Discussion started by: Raynon
2 Replies

9. Shell Programming and Scripting

Difference between two dates in no of days ???

Hi All How to get the difference between two dates in no of days ??? My date format is like this YYYY/MM/DD. I have to get the no of days between two dates in the given format. I tried to search the forum but nothing came up similar to my requitement. Your help will be appreciated. ... (1 Reply)
Discussion started by: csaha
1 Replies

10. UNIX for Dummies Questions & Answers

days elapsed between 2 dates

does anybody know how to find out the number of days elapsed between 2 dates e.g. days elapsed between 020212 and 020110 (YYMMDD format) Thanking you in advance. Ravi. (1 Reply)
Discussion started by: rkkiran
1 Replies
Login or Register to Ask a Question