Distinguishing between data types in one field

[#1]

HI guys,

I have a field which contains an integer such as 975846 but it also contains date inputs in the format of 14/03/2010.

I would like to be able to count each type of input separately. is there a way to distinguish between the two when doing a count, possibly using the LIKE function? Any help would be much appreciated.

Thanks

[Miguel_Angel_Baeyens]

Hello,

Is there any kind of separator between both values? Could you post an example of a couple of values for that field? There are some string functions you can use to separate values in a field, and like function exists as well.

[#3 · Accepted solution]

Hi,

Here you are a possible solution.

I hope this helps you.

Best regards.

[#4]

Thanks Miguel,

That works for me!