Solved

Calculating date difference in days

Posted on 2001-07-28
3
222 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In tuning file systems on the Solaris Operating System, changing some parameters of a file system usually destroys the data on it. For instance, changing the cache segment block size in the volume of a T3 requires that you delete the existing volu…
Introduction Regular patching is part of a system administrator's tasks. However, many patches require that the system be in single-user mode before they can be installed. A cluster patch in particular can take quite a while to apply if the machine…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
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.
Suggested Courses

751 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