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 Mike Lewis 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
Dec 8, 2003
59
0
0
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
Crystal Reports - Group question 1
Replies
2
Views
113
SarahSCPDAdmin
SarahSCPDAdmin
rwwagner
  • Locked
  • Question
Passing date range formula from main report to sub report
Replies
2
Views
125
lbass
lbass
PeteyN.O
  • Locked
  • Question
Crystal Report passing a date parameter to a number type field
Replies
3
Views
61
hilfy
hilfy
Mark.rooker
  • Locked
  • Question
Find closest date
Replies
1
Views
65
lbass
lbass
grecon
  • Locked
  • Question
Cross Tab date Selection?
Replies
1
Views
63
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top