Date Difference

nvuradi · Post by **nvuradi** » Tue Feb 27, 2007 12:15 am

Hi All i have a requirement where in i have to get the difference between two incoming dates as an integer value.

Is there anyway we can get it done. If there is even a part solution, please do post it here. I shall be very thankful.

Thanks
Naru.

kumar_s · Post by **kumar_s** » Tue Feb 27, 2007 12:20 am

There are lot of ways to get it done. If you make a search you will find a lot of idea.
One simple option is to convert the dates into Julian dates and subtract. The idea is to convert the date into internal or integer format.
JulianDayFromDay() can be used for that.

DSguru2B · Post by **DSguru2B** » Tue Feb 27, 2007 9:23 am

Kumar is right, if you look at the DS help of these functions, you will see that JulianDayFromDate() will return an integer. You can perform this function on your incoming dates and do the substraction. If you just need the difference and not concerned about which date is higher, you can also use Abs() function on the result to get an absolute value.