I have been successfully able to update or insert other fileds in the Employee table expect BirthDate. The following SQL when run inserts all fileds except BirthDate. The column appears NULL after insert. Updating the same row runs successfully but updates it to NULL.

INSERT INTO Employee (IsActive, FirstName, MiddleName, LastName,EmployeeAddressAddr1,EmployeeAddressAddr2, EmployeeAddressCity, EmployeeAddressState,EmployeeAddressPostalCode, SSN, Gender, BirthDate) VALUES(1,'Test','C','Test','22 Chester Street','PO Box 112','The Beach','CA','3155','123-45-6789','Female',{d'1953-11-07'})

 Thank you.

I have no idea what version, country or year of QuickBooks you are running, but I just did:

INSERT INTO Employee (IsActive, FirstName, MiddleName, LastName,
EmployeeAddressAddr1,EmployeeAddressAddr2, EmployeeAddressCity,
EmployeeAddressState,EmployeeAddressPostalCode, SSN, Gender, BirthDate)
VALUES(1,'Test','C','Test','22 Chester Street','PO Box 112','The Beach',
'CA','3155','123-45-6789','Female',{d'1953-11-07'})

and got:

I am using QuickBooks Premier - Multicurrency Edition Canadian Edition 2007

Screenshot below:

Sorry, that's a bug in the Canadian edition of QuickBooks that's been fixed in non-multi-currency version of QuickBooks 2008:-

QBCA001404: BirthDate is not returned for EmployeeQuery. Both BirthDate and SIN is not showing in QBUI.

See: Two Versions of Canadian QuickBooks 2008 

Thanks for your reply. Is there an ETA for the fix for this issue?

Thanks.