But I'm adding records to existing data whose date format may differ from this.
Well it definitely does on my iMac. These are the last few records of my database before importing (I've added some empty records):
The first field is a date field, as shown:
I then create an array using this statement:
AllCombosArray = AllCombosArray +cr()+ datepattern(array(FieldsArray,I,cr()),SourceDateOutputPattern) +tab()+ array(CategoryArray,J,cr())
in which the
datepattern( function clearly creates data elements in the form, "1 1 2017". I then import the array with:
and the database then looks like this:
where the records with empty values in the dollar field are the imports. So maybe your machine "definitely won't accept something like 3/5/17" but mine sure does.
Can anybody else make this happen?