The Clarion Advisor: Displaying Clarion Dates In Excel

by Jeffrey Slarve

Published 2002-12-20    Printer-friendly version

If you have a CSV file or other data that contains an unformatted Clarion date, and you wish to view the date in Excel, you'll need to convert the Clarion standard date to an Excel date.

Fortunately, that's easy to do. Just create a formula in another column, subtracting 36161 from the value and formatting it as a date. Clarion standard dates and the Excel DATE() function both have an arbitrary "Day 1" - for Excel, this is 1/1/1900, while Clarion's Day 1 is 12/28/1800 (although the first usable date is Day 4, or 1/1/1801). The number 36161 is the difference in days between these two dates.

---

Jeff Slarve is an independent software developer and the creator of the critically-acclaimed In Back automated file safeguard utility. Jeff has been a Clarion developer since 1991, and is a member of the group formerly known as Team TopSpeed.

Printer-friendly version

Copyright © 1999-2008 by CoveComm Inc. All Rights Reserved. Reproduction in any form without the express written consent of CoveComm Inc., except as described in the subscription agreement, is prohibited.

Clarion Magazine ISSN 1718-9942