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!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to divide dates

Status
Not open for further replies.
PerrinA

PerrinA

Programmer
Jul 26, 2001
15
US
I haven't worked with Crystal Reports much and need some help. I have a spreadsheet with peoples birthdays and their names. I can get Crystal to ouput their age in days but not years. Can I get Crystal to divide the number by 365, or is there a way to covert the date to years? Thank you for your time.
Aybara
 
Sort by date Sort by votes
See my FAQ on common formulas in the General forum. There is a formula for calculating AGE. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

B
  • Locked
  • Question
Difference of a field between 2 variable dates
Replies
1
Views
398
hilfy
hilfy
inkbird01
  • Locked
  • Question
Filters > Record Selection for dates between
Replies
4
Views
541
pmax9999
pmax9999
cursedkorok
  • Locked
  • Question
Group consecutive dates
Replies
12
Views
866
pmax9999
pmax9999
tlbrown88
  • Locked
  • Question
How does one get the results of a Calculation (SharedVar) on the same line as the Sub Report?
Replies
4
Views
621
tlbrown88
tlbrown88
AleXSR700
  • Locked
  • Question
How to find first non-zero decimal place?
Replies
8
Views
608
AleXSR700
AleXSR700

Part and Inventory Search

Sponsor

Back
Top