Prevent string to return date

[Mic]

Hi,

I have an expression of a conditional concatenation that if true returns a string but Appsheet turn this string into a date which produce an error. Here is a screenshot of the situation :

Normal :

Observations :

• All the other conditions return a string (“20-30”, “30-40”, …)
• All the related columns type are “Text” (string). Nothing is set to read or post a date

Any idea how to prevent this ? I had to search so long just for that . For now I will just modify all the texts to prevent Appsheet to transform into a date.

Thanks for any input. Best regards, Mic

[Suvrutt_Gurjar]

May be not very elegant , but for those strings that get converted to date, you could use another concatenate statement such as

CONCATENATE(“10-”,“20”)

[Mic · Accepted solution]

That’s a way !
For now I added a “p” in the string (“p10-20”) and changed the other formula accordingly.

Thanks for your input. Mic

[Suvrutt_Gurjar]

Nice. Got it. You are welcome. Yes , there are many times different interesting approaches to solve a problem.