This is alledegly answered here but the site has gone...
I have a report which is scheduled to run at 7am daily and I want to grab data for the previous 12 hour period (shift patterns).
I am currently doing this manually with 2 parameter fields, StartDate & EndDate.
What a *REALLY* want is a formula to work out what date/time it is, and then run a report with details from 7am-7pm or 7pm-7am.
For example, the report is run a 7.05pm, it will grab data from previous day 7am-7pm. Conversley, if it is run at 7.05am, it will grab data from 7pm-7am the previous day.
Any takers on that one - it's driving me crazy.
Bob. (CR8)
I have a report which is scheduled to run at 7am daily and I want to grab data for the previous 12 hour period (shift patterns).
I am currently doing this manually with 2 parameter fields, StartDate & EndDate.
What a *REALLY* want is a formula to work out what date/time it is, and then run a report with details from 7am-7pm or 7pm-7am.
For example, the report is run a 7.05pm, it will grab data from previous day 7am-7pm. Conversley, if it is run at 7.05am, it will grab data from 7pm-7am the previous day.
Any takers on that one - it's driving me crazy.
Bob. (CR8)