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!

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

Special Fields

Status
Not open for further replies.

ianholmes

Programmer
Mar 24, 2001
61
GB
Is there a Special Field which will pick up a date from a database row, and compute the number of days between it and today ? (Version XI )
Thanks I'm new to this
 
Use a formula like:

currentdate-{table.date}

-LB
 

You could also use DateDiff ("d",CurrentDate,{Table.DateField})

LB, does Crystal default to days when you do it like in your example?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top