between FY date caculation

[Guest]

I need the fiscal year start and fiscal year end in order to find out what
Fiscal Year
this case closed in.
So far I have this calculation to get the Fiscal Year Start Date where I am
trying to get the year it closed then add July 1 to that date for the start
of the fiscal year. Once I can also get the Fiscal Year Close date then I
have to find out if the close date was between those dates?
FYBeginate( DatePart("yyyy",[Date Close]),yyyy)+DateAdd(m,+7,d,+1)
thanks,

 

[Van T. Dinh]

Try:

FYBegin: DateSerial(Year([Date Close]) + (Month([Date Close]) < 7), 7, 1)

 

[Guest]

THANk you
--
Janis

Try:

FYBegin: DateSerial(Year([Date Close]) + (Month([Date Close]) < 7), 7, 1)

--
HTH
Van T. Dinh
MVP (Access)

I need the fiscal year start and fiscal year end in order to find out what
Fiscal Year
this case closed in.
So far I have this calculation to get the Fiscal Year Start Date where I
am
trying to get the year it closed then add July 1 to that date for the
start
of the fiscal year. Once I can also get the Fiscal Year Close date then
I
have to find out if the close date was between those dates?
FYBeginate( DatePart("yyyy",[Date Close]),yyyy)+DateAdd(m,+7,d,+1)
thanks,