jkercheval
Programmer
It appears that in Platnum they use some kind of Julian conversion that is not the standard to store dates. Does anyone know how Platnum converts this number into an actual date?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date conversion
- Thread starter jkercheval
- Start date
- Status
The older Platinum stored their dates as a 6 byte string. The later version uses the Pervasive Btrieve Date data type. This is a 4 byte field where 2 bytes represent the year as an integer and the other two bytes represent the day and month. You can take a look at BtSearch at to view your data and data types.
On a side note if you use the AR Module of Platinum take a look at
Gil
On a side note if you use the AR Module of Platinum take a look at
Gil
JEFFREYCRUZANA
Programmer
try using this
[date] = as the Epicor Date
dateadd(dd,[date] - 639906,'01/01/1753')
[date] = as the Epicor Date
dateadd(dd,[date] - 639906,'01/01/1753')
- Status