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!

use current date

Status
Not open for further replies.
solmskid

solmskid

ISP
Feb 24, 2003
56
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
Status
Not open for further replies.

Similar threads

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

Part and Inventory Search

Sponsor

Back
Top