[sqr-users] Comparision of Values got from the DATEDIFF function -Reg

["KAVALAPARA Aravind Subramanian" <AKavalapara@covansys.com>]

Hi Users,
 
I have a unique problem during the Condition checking for the variables having 
values returned from the DATEDIFF function. My code for getting the values is 
like this.
 
LET #Time_11_Diff = DATEDIFF($Shift_Start_Time,$Time_11,'MINUTE')
LET #Time_19_Diff = DATEDIFF($Shift_End_Time,$Time_19,'MINUTE')  
LET #Time_18_Diff = DATEDIFF($UMP2_Start_Time,$Time_18,'MINUTE') 

IF #Time_11_Diff < 0 AND #Time_19_Diff >  0 AND  #UMP_Count >= 2 AND   
#Time_18_Diff > 0
               
In the above If condition, if all the metioned variables are satisfied then it 
should do the further processing. But I have a few negitive test conditions to 
be validated in which I need to Check for condition like
  
IF #Time_11_Diff = 0 .......................
 
The above condition is truly negitive. But even to that negitive condition it 
is doing the further processing  which should not be done. 
 
Please let me know how to validate this.
 
All responses are appreciated.
 
Thanks,
Aravind.
Confidentiality Statement:

This message is intended only for the individual or entity to which it is 
addressed. It may contain privileged, confidential information which is exempt 
from disclosure under applicable laws. If you are not the intended recipient, 
please note that you are strictly prohibited from disseminating or distributing 
this information (other than to the intended recipient) or copying this 
information. If you have received this communication in error, please notify us 
immediately by return email.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users