Solved

Calculating date difference in days

Posted on 2001-07-28
3
221 Views
Last Modified: 2010-04-21
a while ago, i calculated the difference between two dates in days and now i can't remember how i did it.

any help is appreciated.

thanks, mark
0
Comment
Question by:markx
3 Comments
 
LVL 6

Accepted Solution

by:
bira earned 50 total points
ID: 6330441
Hi

   Use this script

#!/bin/ksh
clear
echo "Enter the first date in the format: YYYYMMDD:"
echo "Example:  20010731"
read first
year=`echo $first |cut -c1-4`
month=`echo $first |cut -c5-6`
day=`echo $first |cut -c7-9`
let x1=0+(1461*(year+4800+(month-14)/12))/4+(367*(month-2-12*((month-14)/12)))/12
let w=0+(3*((year+4900+(month-14)/12)/100))/4
let x1=x1-w+day-32075
echo "Enter the second  date in the format: YYYYMMDD:"
echo "Example:  20010820"
read first
year=`echo $first |cut -c1-4`
month=`echo $first |cut -c5-6`
day=`echo $first |cut -c7-9`
let x2=0+(1461*(year+4800+(month-14)/12))/4+(367*(month-2-12*((month-14)/12)))/12
let w=0+(3*((year+4900+(month-14)/12)/100))/4
let x2=x2-w+day-32075
let z=x2-x1
echo "Here is the number of days between the 2 dates:" $z


 Regards
0
 
LVL 1

Expert Comment

by:leolkk
ID: 6330445
i am interested. please inform me
0
 

Author Comment

by:markx
ID: 6330455
this script works great.  thanks for your help.  mx
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I promised to write further about my project, and here I am.  First, I needed to setup the Primary Server.  You can read how in this article: Setup FreeBSD Server with full HDD encryption (http://www.experts-exchange.com/OS/Unix/BSD/FreeBSD/A_3660-S…
Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question