regarding Date difference (current date minus previous date)

uppalapati2003 · Post by **uppalapati2003** » Sat Feb 03, 2007 2:56 am

hi All,

I have one senario, having 2 dates ie 20-09-2006 and 23-03-1983.
these are the dates ,my requirement is to calculate the difference between those two dates in days format. how to approch this ....any idea
this is in server jobs

regards
shrini

ArndW · Post by **ArndW** » Sat Feb 03, 2007 6:53 am

Convert the dates to internal format and take the difference,

Code: Select all

ABS(ICONV('20-09-2006','D4DMY')-ICONV('23-03-1983','D4DMY'))

DSguru2B · Post by **DSguru2B** » Sat Feb 03, 2007 10:46 am

If you want timestamp difference then you can use KBATimestampDeltaDays by Ken.