Getting Tax Period from current date

[crxftw]

Hello. I need to show Tax Period on its field depending on Pay Date. Tax period starts from 1st April so periods go like that: 1 - April, 2 - May, 3 - June etc. For example if Pay date is 31/07/2011 then Tax Period for this should be shown as 03/2011 as June is 3rd period. Should be pretty easy but I can't figure it out myself. Thanks

[orange]

Do a search on Fiscal year.

Here's one I found
http://support.microsoft.com/kb/210249

[crxftw]

I figured it goes like that: ="Month: " & (Month([txtPayDate])+IIf(Day([txtPayDate])

[crxftw]

I can't edit my posts, amazing forum. Anyway: ="Month: " & (Month([txtPayDate])+IIf(Day([txtPayDate])