I am having a heck of a time trying to get an employee's birthdate to export into Quickbooks.  I thought #07/23/1964# should work,  but it does not.  I am using an append query in Microsoft Access, and all other info exports just fine.  Thank you for your assistance.

ps. my regional settings for short date is mm/dd/yyyy

Sandra

See: How are dates formatted in SQL queries when using the QuickBooks generated time stamps? 

See also: How do I add a new Employee? 

Hi Tom,

I am using an Access append query.  The format  of #02/19/1964# that is suggested does not work. Any other ideas?

Thanks, Sandra

Hi Tom,

I am not getting an error message, it is simply that the date of birth is not showing on the employee I have just exported.  All other info is exported just fine.

I have created a little database to show you my query, but I don't see a way for me to send it to you.  There used to be a way I could attach a database to my message, but I don't see that option here anywhere.

Thanks, Sandra

Oh, you are using the Canadian version of QuickBooks. I recall there are one or two fields that may differently. The problem is related to the different column names for Gender and how the Tax number is called for a EMployee however I just tried:

INSERT INTO Employee (IsActive, FirstName, MiddleName, LastName, EmployeeAddressAddr1,
EmployeeAddressAddr2, EmployeeAddressCity, EmployeeAddressPostalCode, NiNumber,
Sex, BirthDate) VALUES(1,'Sandra','C','James','22 Chester Street','PO Box 873',
'Boronia','3155','123456','Female',{d'1953-11-07'})

with my Australian version of QuickBooks and QODBC v7.00.00.194 and DOB worked for me. See: How do I add a new Employee?  for more.

Using MS Access you simply use 'YYYY-MM-DD' for INSERTs with dates like this:

INSERT INTO Employee (IsActive, FirstName, MiddleName, LastName, EmployeeAddressAddr1,
EmployeeAddressAddr2, EmployeeAddressCity, EmployeeAddressPostalCode, NiNumber,
Sex, BirthDate) VALUES(1,'Sandra','C','James','22 Chester Street','PO Box 873',
'Boronia','3155','123456','Female','1953-11-07')

Attachments are limited to PAID Priority Support through the QSupport Helpdesk. The QDeveloper Forum is about stating the issues and showing how to resolve them. If the above doesn't work, I suggest you turn on the trace log and see what you are sending to QODBC thru the MS Access append query.

See also: How do I turn on the trace log? 

Hi Tom,

I have just updated my QODBC to 7.00.00.194 and tried the following query with the trace log turned on:

INSERT INTO Employee ( FirstName, LastName, SIN, BirthDate )
SELECT "Sandra" AS First, "Couling" AS Last, "634 767 197" AS SIN,"1964-02-19" AS DOB;

The employee is added, but the birthdate field is empty.  There is nothing in the trace log.

Sandra

Could please confirm that the following INSERT statement:

INSERT INTO Employee ( FirstName, LastName, SIN, BirthDate )
VALUES ('Sandra', 'Couling', '634 767 197', {d'1964-02-19'})

fails to insert a DOB when executed in VB Demo.

Hi Tom,

I have just tried the insert statement from VB Demo, and the employee was entered, but with no Birthdate.

Thanks, Sandra