Noob taking baby steps here, I am having a strange problem importing CSV file - saved from the bank checking account register. The file is clean.
My system prefs are set for dates to be rendered 27 FEB 2019 (short) or 27 February 2019 (medium and long). This is how I would eventually like to have them set in my database. The bank output is in the form 2/27/2019.
I used the tutorial to successfully make a checkbook ledger with the dates the way I like them. The field is formatted as a date with the output pattern dd/mm/yyyy. I made a copy of this file and, for a new account, imported the csv, replacing the contents of the database. When I do this, PanoramaX misconstrues the month and day of the month, resulting in empty fields when ever the day exceeds 12.
This happens even when I create a new database from the CSV as follows: the file is imported flawlessly, the Date field contains the right info, however it is text. If I use the Properties window to change it to Dates, the misconstrued dates disappear. I don’t see a way to morph it from a Text type to a date datatype. Can anyone suggest the way to handle this?