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

Set Current / Print date

Status
Not open for further replies.

IanHallett

IS-IT--Management
Sep 27, 2001
15
GB
Hi,

I am using Crystal Reports Version XI to produce an Aged Debtors Listing.

I would like to be able to set the Print date (i.e. CurrentDate value) to a user defined date via a formula if possible. I can then age my report using the Aged0To30Days etc functions which are dependant on the CurrentDate value.

Can anyone help?
 
You can set a working date using a parameter, excluding stuff before it. You can also use DateAdd to set it to a fixed value before the current date, e.g. at least 30 days before.

You can also split the data by month, or quarter or whatever. Choose Group and select the correct date.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top