Date to two digit year, fiscal.

[OMamed]

I've done a search, and have done what I can, but seem not to be able to figure this one out myself, so here goes...

I need to convert a date input into the two digit fiscal year... So if I input 9/13/01, a calculation is done... greater than or equal to 7/1/01 and less than or equal to 6/30/02 then the field gets "02" as the fiscal year. Can anyone help me? I'm just not getting the calculation at all.

Thank you!

[BobWeaver]

You can use this if you don't have any dates prior to year 2000.

Year(MyDateField)+case(Month(MyDateField)>6,1,0)-2000

Otherwise:

Right(NumToText(Year(MyDateField)+case(Month(MyDateField)>6,1,0)),2)