Approach User Support homepage Approach User Support
Answers to Frequently Asked Questions about Lotus Approach
Examples LotusScripts
Example databases
Links to other Lotus Approach support services

[Return to contents]

Importing Dates

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:


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.

[Return to contents]

© Copyright, JohnBrown, Trademarks, Disclaimer, Acknowledgements.