Joined: 21 Feb 2008
Location: United Kingdom
Online Status: Offline
Posts: 1
Topic: How to find difference between two dates Posted: 21 Feb 2008 at 8:33am
Hello thre,
I am in the hunt of getting a correct formula to calculate the difference between two dates. does anyone out there know about it? the logic is to find 'if the diference between two dates is more then two years or less?' Any idea will be helpful.
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 21 Feb 2008 at 6:09pm
Use the DateDiff() function. The first paramter is the interval ("d" for days or "yyyy" for years) and the next two parameters are the dates you want to work with.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
