Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want write expression for difference between to datetime fileds :
Ex : Date1 :03/20/2013:08:23:25
Date2 : 04/20/2013:17:32:02
difference between these 2 dates in expression side.admin
Hi,
use interval() .
Like,
inetrval(date2-date1,'D hh:mm')
If you dont want in hr and mins then remove HH mm
For details check in help file.
Regards,
actully see below
i am assuming date 2 is greater
age(date2,date1) returns difference in days
inetrval(date2,date1,'hh') for difference in hours
inetrval(date2,date1,'mm') for difference in minutes
hope this helps