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!

use current date

Status
Not open for further replies.
solmskid

solmskid

ISP
Joined
Feb 24, 2003
Messages
56
Location
US
use current date in arguement to calculate age of issue
 
Sort by date Sort by votes
Use the datediff function, for instance to calculate the difference in days:

datediff("d", currentdate, {table.Date})

-k
 
Upvote 0 Downvote
GREAT!! thanks for your help.......
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Halliarse
  • Locked
  • Question Question
Installing CR for use with VS2012
Replies
1
Views
613
hilfy
hilfy
ifthenelsenull
  • Locked
  • Question Question
Can I use FOR XML with crystal reports
Replies
0
Views
152
ifthenelsenull
ifthenelsenull
iwm
  • Locked
  • Question Question
How to suppress a date prior to Dec. 31, 1899
Replies
2
Views
287
IanWaterman
IanWaterman
shuber1
  • Locked
  • Question Question
Perform calculation only using details in current group
Replies
8
Views
362
shuber1
shuber1
americvish
  • Locked
  • Question Question
entering datetime parameter as yyyy-mm-dd 00:00:00
Replies
1
Views
245
Madawc
Madawc

Part and Inventory Search

Sponsor

Back
Top