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

Looking for frmula help to display data 30 days after initial date

Status
Not open for further replies.
mvalley

mvalley

Technical User
Mar 4, 2011
80
US
I am trying to run an audit report that will show who access a record 30 days after pt discharge. How can I write a formula to display the cr_audit_datetime to be 30 days after the cr_prdate?
 
Sort by date Sort by votes
you could use the select expert and make it choose only cr_prdate + 30 days or larger dates.

ie:
cr_audit_datetime >= (cr_prdate + 30)

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
475
TPG_IT
T
mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
436
mmck1964
mmck1964
D
  • Locked
  • Question
Comparing two Date Ranges
Replies
0
Views
296
doodledump
D
sofseattle
  • Locked
  • Question
Crystal formula for barcode display shows extra characters in date format?
Replies
1
Views
280
BobSuruncle
BobSuruncle
john432
  • Locked
  • Question
Crystal Report Help 1
Replies
2
Views
307
john432
john432

Part and Inventory Search

Sponsor

Back
Top