DSXchange

Posted: **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

Posted: **Tue Nov 27, 2007 11:39 pm**

JulianDayFromDate(defaultdate) - JulianDayFromDate(CurrentDate())

OR

Use DaysSinceFromDate() function.

Posted: **Tue Nov 27, 2007 11:50 pm**

Thanks KoolNitz

Posted: **Wed Nov 28, 2007 12:05 am**

Thanks KoolNitz

Posted: **Wed Nov 28, 2007 12:13 am**

How about DaysFromDateSince() function?

DSXchange

how to get the no of days between two dates

how to get the no of days between two dates