Beta TPS ODBC (long) Date conversion ?

Quote:

>I tried to use tps beta-2 odbc with MS Query. Tps long-date field is number

>in MS Query and Not Date ? Big Probelm?.

>I had come to know that C4 will have answer for this but what will happen

>to dos tps user. They will never be able to use their data under ODBC? Can

>Some one in Topspeed can answer this issue? Use C4 or forget tps ODBC, is a

>policy ?

From the Help file (TPSODBC.HLP),

To use a field stored as a LONG using Clarion Standard Dates or

Clarion Standard Times, you should create a formula in the product you

are using to access the TopSpeed files. Here are some examples:

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).

BTW: If anyone has examples of formulas to use in other products,

please send them to me or post here. I will include the examples in

future docs.

HTH,

Jim

+============================================================>

| Jim DeFabia TopSpeed Corporation-Documentation

| Standard Disclaimer: These opinions are mine & mine alone.

+============================================================>