Doing date Comparisons in Excel 1

[scroce]

I think this is pretty self explanatory - I know that the syntax is wrong - but can someone point me in the correct direction of what i'm trying to do here?

Public Function FiscalYear(MyDate) As String


Select Case MyDate

Case #7/1/1998# > MyDate > #6/30/1999#
FiscalYear = "FY98"
Case #7/1/1999# > MyDate > #6/30/2000#
FiscalYear = "FY99"
Case #7/1/2000# > MyDate > #6/30/2001#
FiscalYear = "FY00"
Case Else
FiscalYear = "Not Found!"

End Select How much more water would there be in the ocean if it weren't for sponges?

 

[SkipVought]

Hi,
Use

    Case #7/1/1998# To #6/30/1999#

hope this helps Skip,
metzgsk@voughtaircraft.com

 

[scroce]

Thanks Skip.

What a sad world it would be without tek-tips How much more water would there be in the ocean if it weren't for sponges?