INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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.

Jobs

Still getting 1900 instead of 2000 YR calculations

Still getting 1900 instead of 2000 YR calculations

(OP)
Hi new to Forum,

Two questions really. I use Millennium database Software from JSI now MIP which is Xbase.

1. In the templates that come with the software the date ranges print out in 1900's format instead of 2000?  How do I change them.

2. Also with the same templates, they only work with the workfile can reconnect to the data (.dbf) and get any results.

Thanks
Ted

RE: Still getting 1900 instead of 2000 YR calculations

You must have an old version of R&R.  Upgrade to the current version and the date problem will go away.

Howard Hammerman,
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com
http://www.hammerman.com
800-783-2269

RE: Still getting 1900 instead of 2000 YR calculations

Hello Ted, I don't have the answer you're looking for, but I also work with Millennium x-base.  We're on R&R v 6.something - they decided not to pay for the upgrade as it's "working just fine."  I've never encountered your problem, but it's kinda exciting to find another Mill user on Tek-Tips!

RE: Still getting 1900 instead of 2000 YR calculations

hello tvpsc

I used to have the same problem. The problem may be on the data and not the rr6. Try to make a copy of the dbf and replace all yy field with 2000 rather than 00. If this works, you may want to look at the exe that places date data into the dbf and update it accordingly.  

Hope this helps.  

Mel
mel_wwy@yahoo.com

RE: Still getting 1900 instead of 2000 YR calculations

Mel's suggestion is a good one.
Or you could create a user defined formula (UDF) like this:

MillDate(C_x)
iif(left(x,2)="00","2000",x)


You may have to adjust this if the YY field is not a character.  If it is a number then,

MillDate(N_x)
iif(x=0,2000,x)

I have just finished working with a Millennium user as they were moving from the xbase version to the SQL version and from R&R to Crystal.  

Let me know if I can help.

Howard Hammerman,
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com
http://www.hammerman.com
800-783-2269

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!

Resources

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