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

Date formula as parameter for report

Status
Not open for further replies.

bdjb

Technical User
Oct 29, 2002
292
US
Hello All,
I need to run a report each Friday that will pull data from the Previous Friday (7 days) to the Previous Thursday (1 day). I have formulas to determine the Friday date and the Thursday date, but how can I use them in the record select expert to get a range?

I know I'm missing something simple, but keep hitting hy head on the wall!

Thanks in advance,
Bob

What happens if you get scared half to death twice?

Bob
 
Is it acceptable to just get prompted for a date range, or do you want a formula that will automatically pick the last Friday through the last Thursday?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
 
HI,
I was looking for a formula, so the report can be automated. I had it set up with parameters, but if I'm not at work, no one runs it.
Bob

What happens if you get scared half to death twice?

Bob
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top