How to distinguish number and Date in same column

[#1]

Hi,

I have one column that contains both date and number. I want to distinguish between them for an if condition. I have tried functions like istext and isnum but for both value it seems that condition is getting true.

Is there a way to resolve this?

[#2]

Dates are numbers, which is why it would show TRUE for both.  What kind of numbers are in the field with the dates?

[#3]

normal float numbers like 0.0275 etc..

[#4]

What is your reason for having the two types in one field? You may be able to use a range, since dates are serial numbers (e.g. Jan 1, 1900 is 1 and May 5, 2014 is 41764), but if some of the "numbers" fall between your range that should not be considered dates then you would get wrong results.

[#5]

Do not mistake that to mean that dates are integers, however.  If the number was 41764.52 then it would technically be May 5, 2014 12:28:48 PM. 

[#6]

Thanks a lot Rebecca for your response. I resolved that using if condition.