difference of dates

mandla.srinivas · #1 (**permalink**) 01-05-07, 14:34

In what way I can get the difference of 2 dates in months.

say
date1 is '04/23/2006'
and
date2 is '02/23/2005'

The difference between these 2 dates is 14 months.
writing which query I could get this result.
Could you please help us in getting the query

n_i · #2 (**permalink**) 01-05-07, 17:25

Simple statement like

Code:

values date('04/23/2006') - date('02/23/2005')

will give you a number like "10200", where "1" is the number of full years, "02" is the number of months, and "00" is the number of days between the two dates. It should be easy to calculate the number of months from there.

Internet Services

Web Development

Digital Marketing

Consumer Tech