Date fields inside Shapefiles

[TatMa]

I have a Shapefile that contains two Date fields. ArcGIS Explorer Desktop can see the Attributes and values but Query Builder
does not display the Date fields for use in querying. Query Builder also does not display the FID either. Is there a reason for this?

[MarkBockenhauer]

Not exactly sure why the ID and Date fields do not show.  But you can still type them into the "Select features where..."  text box.  For example to select a date you can use.

datefield = date '1903-08-23'

<name of your date field> = date 'yyyy-mm-dd'

-mark