Automatically populate Fiscal Year field

mitchem1

Registered User.
Local time
Today, 18:32
Joined
Feb 21, 2002
Messages
153
Would it be possible to populate a Fiscal Year field by somehow looking at the system date? Our fiscal year runs from July 1 to June 30. What I want to happen is if the month is January through June, I want the field to display the current year. If the month is July through December, I want the field to display the current year + 1.
Thank you for your help.
 
You can use the Month() and Date() functions to get the month. Test for <7 and populate your field accordingly.
 
Sorry, I am no expert. Is something like this the right idea?

IIf Month(<date>) < 7, Year(<date>), Year(<date>) + 1
 
Conceptually, sure.
 

Users who are viewing this thread

Back
Top Bottom