What is the proper format to enter a date in a data loader query

[RToronto]

I am trying to create a date query which references the Account record Created Date in the data loader but the system responds that I'm not using the proper format.  How should I enter a date if I want to retrieve all account records with a created date after January 1, 2006?

Thanks

Rich Toronto 

[jeffstuit]

The SOQL would look like this:

select id from account where createddate >= 2006-01-01

[jdivosevic]

Date - YYYY-MM-DD
Date/Time - YYYY-MM-DDThh:mm:ssZ

[tennvol88 · Accepted solution]

FYI for anyone who comes across this thread, the query above is not valid.  Since CreatedDate is a Date/Time field, the time must be included in the query.

Message Edited by tennvol88 on 07-09-2008 01:51 PM