Joined: 30 Jun 2010
Online Status: Offline
Posts: 3
Topic: Issue Comparing Dates Posted: 30 Jun 2010 at 8:11am
Hello all,
I am fairly new to Crystal and have run into an issue.
I have two date fields (Date_due and Date_received). Based on those dates, I have an if statement (if date_received is <= Date_due then 'On-time' else 'late') and it works fine until it comes to the end of the year. If I have a due date of 01/05/2010 and received date of 12/29/2009, Crystal incorrectly labels this as late, even though it isn't.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 30 Jun 2010 at 10:40am
you could use DATEDIFF() and if the result is <= 0 then it is On-time. Look up in help for the exact syntax...I get the dates confused and the first parameter is slightly different from its SQL counterpart.
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
