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
regarding Date difference (current date minus previous date)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 70
- Joined: Thu Nov 09, 2006 2:14 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'))
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
If you want timestamp difference then you can use KBATimestampDeltaDays by Ken.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.