difference between dates

[raghu]

hi ,
i want to display the difference between to dates(that should be number).
i used _days_between function......but it is throwing an error (RSV-SRV-0040 )...please help me to suit out this error

[rockytopmark]

"i used _days_between function"
Well, that certainly is the function you need to use.

You should send the syntax you tried, and the resulting error, in order for us to be able to see what you might have wrong. 

Also, make sure you are comparing actual date data types with this function.  If your "Dates" are really number that is a reason to get an error.  If they are not dates, you will need to convert them to dates first, then wrap the days_between function around them.

[Suraj]

You may have to cast the dates before you use _days_between function as it only looks for date/time formats to do the calculation.