php - Undefined function 'CONVERT' in expression in Microsoft Access

one text

Solution:

There's no such thing as CONVERT in Access SQL.

Instead, each conversion has a separate function, e.g. CDate, CInt, CStr, etc.

Swap CONVERT(date, with CDate(. Note that date conversions in Access assume either yyyy-mm-dd or mm/dd/yyyy.

See https://learn.microsoft.com/en-us/office/vba/language/concepts/getting-started/type-conversion-functions for the full list of conversion functions.