Automatically populate Fiscal Year field (1 Viewer)

[mitchem1]

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.

 

[pbaldy]

You can use the Month() and Date() functions to get the month. Test for <7 and populate your field accordingly.

 

[mitchem1]

Sorry, I am no expert. Is something like this the right idea?

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

 

[pbaldy]

Conceptually, sure.