fiscal year

[RedGoneWILD]

i have a drop down box with a list of fiscal years. i need a way to take the current date and compare it to the fiscal year range (july 1st-june 30th) and then select the appropriate fiscal year from the drop down box on startup. The drop down box can then be changed to whatever the user wants to view, but i want the current fiscal year to be loaded as default.

any ideas?

[trb5016]

There's probably a way to do this using the default property of the combo box but I never have much luck with that.

What I would do is in the "On Form Open" event put the following code:
(This assumes that your combo box holds fiscal year as an integer and the "2009/2010" would be stored as 2009 but that can be easily changed)

If Month(Date) < 7 then
           [ComboboxName].Value = Year(Date) - 1
Else
           [ComboboxName].Value = Year(Date)
End If

[RedGoneWILD]

no, the fiscal year is a string like "2009-10" or "2010-11"

im assuming month(date) returns an integer...so since it's august, that would return 8 correct? and month(date) goes off of the system time right?

i should be able to figure something out to make it work

thanks

[trb5016]

no, the fiscal year is a string like "2009-10" or "2010-11"

im assuming month(date) returns an integer...so since it's august, that would return 8 correct? and month(date) goes off of the system time right?

i should be able to figure something out to make it work

thanks

That's correct, Month() returns an the integer of the month. August would be 8, and Date pulls the date from the system date.

Adapting my previous code to fit your fiscal year format:

If Month(Date) < 7 then
           [ComboboxName].Value = CStr(Year(Date) - 1) & "-" & Right(Year(Date),2)
Else
           [ComboboxName].Value = Year(Date) & "-" & Right(CStr(Year(Date)+1),2)
End If

[RedGoneWILD]

awesome, that works well....thank you!