AppSheet automatically converting text values to date values in formulas

[Chris_Bellamy]

Hello all,

I was attempting a lookup for the Display Name property of one of my columns.  I attempted to look up a value of "1.1.1", and in doing so AppSheet must be seeing that value as a date automatically, and is attempting the lookup using a date value instead of just the text value.  The field I'm attempting to lookup is correctly a text format, and not a date.

How can I lookup a value of "1.1.1", or "1.2.1" without AppSheet thinking it's a date?

Thank you!