Solved: Valid if on date text - Page 2

Peter_Kalu · 08-01-2023 02:21 PM

Hello all,

I have a special situation where date columns on Appsheet are not parsed properly on SQL database. So, I'm forced to change the column to TEXT in Appsheet. However, I need to enforce validation on the column to only accept this format dd/mm/yyyy. How can I do that with an expression?

Peter_Kalu

Since the default date format for Appsheet is mm/dd/yyyy, I went with this valid_if expression instead

AND(
COUNT( SPLIT( TRIM([_THIS]), "/"))=3,
ISNOTBLANK(DATE(TRIM([_THIS])))
)

View solution in original post