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

Looping Formula Help!!!

Status
Not open for further replies.

keanolin

MIS
Mar 3, 2004
2
FR
A report that I am writing is grouped by days and within that has information which has a start of that date. I would like this information to occur daily until the end date has surpassed. I think that this may be a looping formula?

So far I have got to

If "End Date => current date then......???

Desperate for help!!!
 
Assuming Crystal 8.5, you could try something like
Code:
if {your.date} > {End.date} then "Other"
else totext({your.date}, "For yyyy-MM-dd")
This splits dates, puts them in order and lumps the rest as 'Other'. You could also suppress the group for 'Other'.

Madawc Williams
East Anglia, Great Britain
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top