Financial Year Calculation

[Edutrack Australia]

I have a solution that up till now, customers pay an annual fee based on the current year. We now want to have the option of having customers pay their annual fee based on the financial year (ie July - June). Our password has been linked to the current year, so that any previous password codes don't work when the year rolls over.

How do I do this for the Financial Year? I need a calc field that checks the system date and decides which financial year it is presently in. I then need to build this into the password checker field so that it can run both types of passwords similtane ously.

Regrds

Edutrack

[Lee Smith]

I'm a little confused by your use of password here. Is this a true "password" as in allow access to files. OR, is this a code to expiration of fees?

[RussBaker]

Download my Handy Bits post in the Samples section of this forum. There is a calc in there (under the Dates Tab) which returns the Aussie FY in which a date lies. If you sort the Samples by the Views column, Handy Bits will be up near the top.

[Edutrack Australia]

The latter - it is a built-in code that reverts the solution to a 'demo' version when the code is not entered or does not match. It has nothing to do with the FMP passwords.

It works well and means that the solution brings in an annual income for as long as the customers want to use it.

Regards,

Edutrack

[Edutrack Australia]

Thanks Russ - I will give it a burl and get back to you.

Regards,

David

Edutrack Australia