Calculate fiscal year, something wrong in code

[securitywyrm]

I am trying to update the data for [fiscalyear] based on the [DateStart] of an event.



Here's my current code. Fiscal year rolls over in October.

IF(Month([me.DateStart])>9) then
 me.FiscalYear=(Year([me.DateStart])+1))
 Else
  me.fiscalyear=(Year([me.DateStart])
EndIf

I've tried putting this in an 'afterupdate' event, no luck. It errors and highlights the me.FiscalYear=(Year([me.DateStart])+1)) part.

What am I doing wrong?


EDIT: Found code that works not using the IF command

Me.FiscalYear = Year(DateAdd("m", 2, DateStart))

Still curious why the if version of the code didn't work.

[Perceptus]

try
me.fiscalyear=(Year(Me.datestart)+1)
or
me.fiscalyear=(year(me!datestart)+1)

[moke123]

heres a function...

Public Function FinancialYear(dtmDate As Date)


    Dim fyr As String
    fyr = "6/30/" & Year(dtmDate)    'set month and day to the last day of fiscal year


    If dtmDate > DateValue(fyr) Then
        FinancialYear = Year(dtmDate) + 1
    Else
        FinancialYear = Year(dtmDate)
    End If


    'Debug.Print FinancialYear


End Function

[Micron]

securitywrym: Anything surrounded by square brackets is interpreted as a field name. If it's in a query field, it will prompt for a a criteria value for the field it's in. That is the difference between your 2 code examples. You were referencing a single field [me.fieldname] which doesn't exist. In fact, you don't need the brackets at all. Me.FieldName would be enough. Only if the field name (including control names) contains spaces, certain other special characters, or starts with a number would you need them. All of those situations should be avoided.