Help my if statements don't work on odbc imported date columns

[nitecat]

Can anyone help me understand why my if statements don't work on odbc imported data (date columns)</SPAN>



=IF(DATE COMPLETED="","",1*(DATE COMPLETED>DATE DUE))
= if($B1<=$A1, "1",if($B1>$A1,"0","")) </SPAN>

for example the above if statement only considers or looks at the first 2 digits in the date format and has totally ignored the month ‘DD/MM/YYYY’ and returns 1 instead of 0</SPAN>


Due date completed date</SPAN>
01/03/2012 - 28/02/2012 =0 as completed before due date</SPAN>

 

[Trevor G]

Is the date coming in as a USA format rather than UK format?

 

[nitecat]

Hi Trevor


I've looked at the format cellls - date - format = english uk

 

[nitecat]

problem resolved