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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

date question CR7

Status
Not open for further replies.
be1s

be1s

Programmer
Joined
Dec 8, 2003
Messages
59
Location
US
I need to pull birthdates of individuals who are 9 months old or less. I thought I can use the datediff funtion but it's not supported in ver 7?

Any tips would be helpful.

Thanks.
 
Sort by date Sort by votes
You could approximate this by using:

{table.birthdate} > currentdate - 274

-LB
 
Upvote 0 Downvote
datediff() is available via a download in any version of crystal. Search the BO website and you will find this.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SarahSCPDAdmin
  • Locked
  • Question Question
Crystal Reports - Group question
Replies
2
Views
753
SarahSCPDAdmin
SarahSCPDAdmin
rwwagner
  • Locked
  • Question Question
Passing date range formula from main report to sub report
Replies
2
Views
771
lbass
lbass
PeteyN.O
  • Locked
  • Question Question
Crystal Report passing a date parameter to a number type field
Replies
3
Views
434
hilfy
hilfy
Mark.rooker
  • Locked
  • Question Question
Find closest date
Replies
1
Views
385
lbass
lbass
grecon
  • Locked
  • Question Question
Cross Tab date Selection?
Replies
1
Views
413
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top