Difference between dates

[#1]

How to get difference in days between today's date and some other date. Say difference between 4/26/2012 and 4/18/2012 ?

[kaushiknsolanki · Accepted solution]

HI,

    You can also use interval() function like shown below.

    interval(Date1 - Date2,'d')

    Here you can give parameter as d for days,hh for hours,ss for seconds,  depending on the requirement of differece.

Regards,

Kaushik Solanki

[#3]

Thanks Kaushik