Problems with converting a date as text to a date

[DashboardNovice]

The following formula is evaluating as TRUE, when it should be false.

=IF('Overall Depreciation Schedule'!F34<="12/31/"&'2012 - Depreciation'!$B$2,"Yes")

F34 = 4/23/2013
B2 = 2012

Cell B2 has data validation. The list values are years. The format on B2 is General.

 

[Hui]

F34 is a Date
but "12/31/"&'2012 - Depreciation'!$B$2 is a text string

Try this instead:
=IF('Overall Depreciation Schedule'!F34<=DATE('2012 - Depreciation'!$B$2,12,31),"Yes")

 

[DashboardNovice]

F34 is a Date
but "12/31/"&'2012 - Depreciation'!$B$2 is a text string

Try this instead:
=IF('Overall Depreciation Schedule'!F34<=DATE('2012 - Depreciation'!$B$2,12,31),"Yes")

Nice. It worked out perfectly. The other thing I tried was using the TEXT function to convert that text string to a date but that didn't work.

Thank you for your answer.