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

CurrentDate in formula

Status
Not open for further replies.
dmccallum

dmccallum

Programmer
Jan 5, 2001
90
US
I need to calculate the aging of some invoices. In my report I need to subtract Due_Date(a string) from CurrentDate(date of report) but every formula I try fusses that CurrentDate is not a string. How can I work around this?
 
Sort by date Sort by votes
To do date math you have to convert your string date to a true date. How you do this depends on what format your date string is stored in. See my FAQ in the general forum on common formulas. There is one that converts a string date to a true date. You can also try the DateValue() function. Ken Hamady
On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
2K
TPG_IT
T
john432
  • Locked
  • Question
OLE Objects in your formula 1
Replies
2
Views
553
john432
john432
Corinne30
  • Locked
  • Question
Division of currency formula with/without rounding
Replies
7
Views
1K
dgillz
dgillz
Tichaona
  • Locked
  • Question
Row numbering formula not working
Replies
4
Views
553
lbass
lbass
john432
  • Locked
  • Question
Crystal Report formula (finding with key words) 1
Replies
2
Views
566
john432
john432

Part and Inventory Search

Sponsor

Back
Top