Post Author: TgrBob
CA Forum: Formula
I am creating a report, that for selection criteria, needs to look at all training records since the previous July 1. Our fiscal year runs from July 1 through June 30 of the next year, so whenever the user runs the report I need it to look at the current fiscal year.
For example, the current date is 5/17/07. I need the report to look back at all training records since 7/1/06.
Another example is if the current date was 8/20/07, I would need it to look back at all training records since 7/1/07.
If anyone could give me some sample code on this, I would appreciate it. Thanks!