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

Date range show inventory of current date up to one year ago

Status
Not open for further replies.
dube5878

dube5878

IS-IT--Management
Sep 16, 2011
2
US
I need a crystal formula for an inventory report that will show me products we have in inventory that was ordered from the day i run the report to exactly one year ago. I cannot find anything to work where you can use the current date.
 
Sort by date Sort by votes
{table.date} in dateadd("yyyy",-1,currentdate) to currentdate

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
151
SoftwareRT
SoftwareRT
rwwagner
  • Locked
  • Question
Passing date range formula from main report to sub report
Replies
2
Views
224
lbass
lbass
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
262
hilfy
hilfy
RoknRole
  • Locked
  • Question
Static parameter list of values limitation
Replies
1
Views
131
RoknRole
RoknRole
PeteyN.O
  • Locked
  • Question
Crystal Report passing a date parameter to a number type field
Replies
3
Views
100
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top