how to get the no of days between two dates

uppalapati2003 · Post by **uppalapati2003** » Tue Nov 27, 2007 11:03 pm

Hi all,

i have to columns(defaultdate,current date ) i want to get difreence between these two columns .output column is days the datatype of this field id smallint..if any body have some idea please let me know

thanks

koolnitz · Post by **koolnitz** » Tue Nov 27, 2007 11:39 pm

JulianDayFromDate(defaultdate) - JulianDayFromDate(CurrentDate())

OR

Use DaysSinceFromDate() function.

uppalapati2003 · Post by **uppalapati2003** » Tue Nov 27, 2007 11:50 pm

Thanks KoolNitz

uppalapati2003 · Post by **uppalapati2003** » Wed Nov 28, 2007 12:05 am

Thanks KoolNitz

ray.wurlod · Post by **ray.wurlod** » Wed Nov 28, 2007 12:13 am

How about DaysFromDateSince() function?