I've configured NI's MAX to export data (from a Citadel 4 database generated by Lookout 5.1) to a CSV file and when viewed in MS Excel, there are only timestamps and no associated dates. When I format the cells for a custom date & time (m/d/yyyy h:mm:ss), the result is 1/1/1900 16:21:34 (with 1/1/1900 returned for all records), for example. When I format the cells for a general number format, it's evident from the result 0.681639 that no date value (in the integer portion of the timestamp) is exported from MAX.
Any thoughts or suggestions?
John T. Sampson
