Date Function

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!