Re: Date format exasperation

> The format of the contents are always in the File Format - independent of any 
> "Use >System Formats" setting or Data Entry setting (Always use current 
> system settings/>Always use file's saved settings/Ask whenever settings are 
> different).
>
> If you want to change the File Format so the date format is "dd/mm/yyyy", you 
> need >to (1) verify the current OS Level System Settings for dates is 
> "dd/mm/yyyy"; (2) "Save >A Copy As ... Clone"; and (3) open the clone on this 
> System with the date format set >to "dd/mm/yyyy".

This is helpful, as it wasn't clear to me that the "File format"
wasn't tightly linked to the "Use system formats" settings.

The truly aggravating part is that I have done the clone procedure
several times and it makes no difference. A text field containing a
dd/mm/yyyy string still does not evaluate (when using GetAsDate) to a
valid date. However, it seems if I create a no records clone and
re-import all the data, then things begin to look up.

Thanks for your help on this.