Skip to main content
Skip table of contents

Date of Birth script

This support note applies to:

  • AE Practice Manager (NZ)
  • AE Practice Manager (AU)

These instructions require technical expertise

Make sure you know what you're doing and are using one of the products listed. If you're not sure, ask your IT professional or MYOB.

Article ID: 33403

In MYOB Accountants Enterprise Practice Manager (AE PM), Date of birth is a field which can be added as a column header in the Find Clients screen.

The Date of Birth field/values may be formatted differently across your clients, depending on when the client was created or last modified.  This may cause issues if you want to search or filter on this column.

The PM_5_0_FormatDateOfBirth.sql will re-format all the dates of birth to a consistent format.  For example 02 May 2011.

Before running this script please make sure you have a backup of your AE PM database.

For details on how to backup SQL and how to run a script, refer to the following articles:



Script saved to X:\Products\Solution6\Viztopia\00 Scripts and Hotfixes\Release 5.0\FormatDateOfBirth

Change to Find clients screen occurred in V5.0

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.