This topic is locked
[SOLVED]

 Calcuate period between two dates

12/1/2012 1:18:17 AM
ASPRunnerPro General questions
A
adnankmk author

I am using asp runner6.2. I having a problem in calculating period between two dates. I want to calculate the date period of two dates automatically. Can any body help me.

admin 12/2/2012

You can do that using database specific functions in SQL Query. For instance, in MySQL you can use DATEDIFF function:

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_datediff