RE: Serial Date formula

[Chris Bipes <chris.bipes@xxxxxxxxxxxxxxx>]

Take your date 20010318 and subtract 36968 to find your starting point.  Now
that is your seed date.

DateToConvert - SeedDate = NumberOfDays 



Christopher K. Bipes      mailto:ChrisB@Cross-Check.com
Operations & Network Mgr  mailto:Chris_Bipes@Yahoo.com
CrossCheck, Inc.                  http://www.cross-check.com
6119 State Farm Drive     Phone: 707 586-0551 x 1102
Rohnert Park CA  94928    Fax: 707 586-1884

-----Original Message-----
From: Chris Beck [mailto:CBeck@good-sam.com]
Sent: Thursday, April 12, 2001 1:13 PM
To: MIDRANGE-L@midrange.com
Subject: Serial Date formula


Can someone tell the formula to convert 20010318  to 36968.

This would be just like the DATEVALUE in Excel.  

Thanks
Chris
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---