Lookup function showing date as number

[ScottinNC]

How can I change the date format to show the date and not the number format when using the lookup function

[jyothis_m]

Whether the column type for the column being searched is of type DATE

[SkrOYC]

Is this AppSheet-related?
Where is your LOOKUP() expression?

[ScottinNC]

Yes, in Appsheet, I am using the lookup(), to reference a date listed within a table. The function is working correctly, but I am getting an error message when attempted to select the Date type. The column in the Google Sheet is set to Date.

[ScottinNC]

Forgot to add, this formula is in the initial value field.

[dbaum · Accepted solution]

Confirm that the [Last Engagement Discussion Date] column within AppSheet has its Type property set to Date..

[ScottinNC]

@dbaum Thank you for that. Sometimes the simplest of error can cause the greatest pain. It is showing correctly now.