I can import checking account data as .csv file, but all columns (fields) are text. Is there a way to convert the text field to a date field?
What form does the "date as text" in the csv file take? Does it match the input format for dates in your FileMaker application? If so, you might be able to import directly into a date field. If not, you could set up date field with an auto-enter calculation that takes the text and converts it into a date during import. (Enable auto-enter options for the import.)
The exact form of that calculation will depend on the format of the date in the csv file.
Open your csv file in Excel and change format of a column to Date
Retrieving data ...