Calculate Date Field using Field Calculator in file geodatabase

Discussion created by loreenhodgkinson on Nov 19, 2010
Latest reply on Feb 14, 2014 by mapperrine
I have a date field in a file gdb and i am trying to calulate the field to be a particular value, January 1, 2006.  I am using this exprssing in the Field Calculator:

date '2006-01-01'

but it is just returning today's date.  What am I doing wrong?  It seems to me this should be very simple...