First Trx Date in SQL

First Trx Date in SQL

I am trying to get the first trx date by joining Zoho CRM Accounts, Zoho Books Contacts, and Zoho Books Invoices.

I can get my expected results, but the first trx date column is no longer a date field, I believe its a string, which is not ideal for reporting filters.  I am updating my SQL to CONVERT the field to a date field:

SELECT 
         "Account id",
         "Account Name",
 "Account Type",
     CONVERT(DATE,MAX("Invoice Date"),23) AS lasttrx,
 MIN("Invoice Date") As first_trx,
         COUNT("Invoices (Apliiq Inc)"."Invoice Number"),
         SUM("Invoices (Apliiq Inc)"."Total (BCY)"),
         AVG("Invoices (Apliiq Inc)"."Total (BCY)")
FROM  "Invoices (Apliiq Inc)" LEFT JOIN "Contacts (Apliiq Inc)" ON "Contacts (Apliiq Inc)"."Customer ID"  = "Invoices (Apliiq Inc)"."Customer ID"  LEFT JOIN "Accounts" ON "Accounts"."Account Id"  = "CRM ID"  
WHERE "Invoices (Apliiq Inc)"."Invoice Status" = 'Closed'
GROUP BY "Account id", "Account Name",  "Account Type";


However, I am receiving this error:

Argument count mismatch for function CONVERT

Any help is appreciated.