Finding 1st day of current financial year

[Rick-K]

Hi, I have a very simple task that I am getting really confused over.

I have a form which calculates the totals of various currency fields in records between 2 dates which can be changed by the user but which start at "default" dates when the form is loaded.

The default end date is the current date, Date(), that one is easy.

The default start date needs to be the "previous" 1st April

i.e current date is "12/07/2011" (UK short dates) and the start date needs to be "01/04/2011". In March 2012 the start date will still be "01/04/2011" but after 1st April 2012 the start date needs to be "01/04/2012"

Can someone point me to a simple formula to calculate the start date from the current date please before I go completely bald

Rick

 

[bob fitz]

Hi Rick

This is untested, but you may like to try:

"01/04/" & Year() -1

 

[Rick-K]

Bob

Thanks for the fast response, however I fear that will not work as surely it will return "01/04/2010" for today's date while I need "01/04/2011"

However your idea was sufficient to unblock the thought process and this

="01/04/" & IIf(Month(Date())<4,Year(Date())-1,Year(Date()))

Does work

Many thanks for your time

Regards

Rick