×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Dates in btrieve

Dates in btrieve

Dates in btrieve

(OP)
Currently I dump data from btrieve 6.x files to asci files but I have a problem to convert the dates when I import this into MS Access 2000. A number of 729647 must equal 15/09/98. Can anybody help me please. Thanks

RE: Dates in btrieve

Dear Wyngate,
First off, since this forum is international in nature, I will use the IS0 8601 standard for dates which is YYYY-MM-DD format.

If you examine the magical number 729647, it is the number of days since 0001-01-01 reckoned as number 1. The storage in Btrieve you refer to is in "Integer Date" format and the date you refer to 1998-09-15 is day number 729647.

MS products also uses the integer date format with 1900-01-01 as number 1.

No Y2K or YXK problems. Neat huh.

In both storage, since dates are stored as numbers and not any ambiguous format, calculations on dates can be done. So if you have a date variable DateSale and an expression like DateSale + 15 you are actually adding 15 to a number. The end result is that your software will translate that number you refer to 729647 and show it to all and sundry translated to human understandable as 1998-09-15.

Your question how to parse a Btrieve date to Access 2000, update the MS Access field with Btrieve field less 693595.

The Gregorian calender repeats years exactly one 28 years. There seems to be a glitch in MS or Btrieve algorthyms for this. Don't have MS Access, please experiment with this first.


Regards

RE: Dates in btrieve

(OP)
Thanks a million for your help!!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close