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

nitecat

New Member
Joined
Mar 28, 2013
Messages
6
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>
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,704
Office Version
  1. 2016
Platform
  1. Windows
Is the date coming in as a USA format rather than UK format?
 

Watch MrExcel Video

Forum statistics

Threads
1,133,538
Messages
5,659,384
Members
418,500
Latest member
Guru Prasad S

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top