Financial Years

[Guest]

I have a transactions subform where by for a particular transaction i enter
the date of the transaction, and i would like to be able to tell which
financial year
(1/07 – 30/6) each particular date fell in, using a caluclated field within
that transaction record.

eg:
Transacton Date Fin Year
1/4/05 04/05
31/6/05 04/05
1/7/05 05/06

Thanks in advance

 

[John Vinson]

I have a transactions subform where by for a particular transaction i enter
the date of the transaction, and i would like to be able to tell which
financial year
(1/07 – 30/6) each particular date fell in, using a caluclated field within
that transaction record.

eg:
Transacton Date Fin Year
1/4/05 04/05
31/6/05 04/05
1/7/05 05/06

Thanks in advance

You can use a calculated expression:

Fin Year: Format(DateAdd("m", -6, [Transaction Date]), "yy") & "/? &
Format(DateAdd("m", 6, [Transaction Date]), "yy")


John W. Vinson[MVP]