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.

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:

• Backing up an SQL database using Management Studio
  
• Running an SQL script in AE/AO