The Clarion Advisor: Displaying Clarion Dates In Excel
Posted December 20 2002
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.
Search ClarionMag
From the archives
The New Clarion.NET Template Language - Is It Really Microsoft's T4?
10/22/2009 12:00:00 AM
At the Aussie DevCon, SoftVelocity president Bob Zaunere demonstrated a template written in the new .NET template language. But is it a new template language? Dave Harms argues it's really Microsoft's T4, and explains why that's a good thing.