I am new to Access reports and am trying to sort a report by fiscal year, FY2006 is 7/1/2005-6/30/2006. The effective date field that I need to use to get fiscal year in the table is in the format m/dd/yyyy. I've tried using iif but need more than just two choices. Thanks.
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Report Expression 1
- Thread starter rwmyers
- Start date
-
1
- #2
Your fiscal year can be calculated by finding the Year() of the date field + 6 months:
FiscalYear: Year(DateAdd("m",6,[YourDateField]))
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
FiscalYear: Year(DateAdd("m",6,[YourDateField]))
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
- Status
Similar threads
- Locked
- Question
