Clarion Date (Long) -> Access Date\Time 
Author Message
 Clarion Date (Long) -> Access Date\Time

Greetings all,

How do you move a Clarion Date (Long) to an Access Date\Time?

Thanks in advance

joe van niekerk
------------------------
Topspeed South Africa
Cape Town
South Africa


Home of the MAPI \ ezHelp and CWWinReg Templates



Sun, 28 Nov 1999 03:00:00 GMT  
 Clarion Date (Long) -> Access Date\Time


Quote:
>Greetings all,
>How do you move a Clarion Date (Long) to an Access Date\Time?
>Thanks in advance
>joe van niekerk

This is how to do it for the TopSpeed ODBC driver:

Converting a Clarion date to a Microsoft Excel Date: Subtract 36161
from the Clarion date value.

Converting a Microsoft Excel date to a Clarion Date: Add 36161 to the
Microsoft Excel date value.

Converting a Clarion time to a Microsoft Excel time: Divide the
Clarion time value by 86400 (the number of seconds in one day), then
divide by 100 to express as a decimal value.

Converting a Microsoft Excel time to a Clarion time: Multiply the
Microsoft Excel time value by 0.0000001157407407407410 (1 divided by
the number of seconds in a day; includes the adjustment to convert
back from a percentage).

HTH,
Jim

+============================================================>
| Jim DeFabia         TopSpeed Corporation-Documentation

| Standard Disclaimer: These opinions are mine & mine alone.
+============================================================>



Sun, 28 Nov 1999 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Create Time / date or Modified Time / date of a txt file

2. convert labview date/time to excel date/time

3. DOS compressed date/time into real date/time

4. TimeStamp class>>date:time:

5. how to convert clarion date to sql date

6. Clarion date to MS SQL date.

7. Dataflex dates to Clarion dates

8. Free class for Clarion 4/5 - Date and time elapsed functions

9. Date & Time Stamps on OPEN Clarion Files

10. ABSOLUTE DATES: Coverting from Clarion DOS to Access 97

11. SQL Toolkit -- problem searching Date/Time field in Access

 

 
Powered by phpBB® Forum Software