 |
 |
 | |
 | |
 | |
 |
|
|
| |
| |
| |
|
Last updated: before December, 1998
It was once said that Approach only recognizes date field in mm/dd/yy format, but apparently it handles dd-mm-yy date format OK when importing a .csv file. If possible you should probably export the data from the old application using mm/dd/yy format as it seems to be the most reliable. Try using a dBase export filter if the program has one.
If you are not able to do this and are therefore importing dates that are currently stored in a different format then you will need to import them into a text field, and write some macros to convert the data in to mm/dd/yy format.
E.g. to convert yyyy-mm-dd to mm/dd/yy a macro would use the formula:
TextToDate(Combine(Middle(initial_date,6,2),'/',Middle(initial_date,9,2),'/',Middle(initial_date,3,2)))
EXCEL uses a slightly different method of calculating dates than 'industry standard' adopted from 1-2-3. This means that imported EXCEL dates are 366 days out. The easiest way around this is to export the data from EXCEL into dBase file and import it into Approach from there.