Subject Including year in search of timestamp field
Author bhata
I'm using CONTAINING to search any field in my table. On a TIMESTAMP
field I have determined how to search on almost everything except for
a date which includes the year.

For example if my field contains: 01/02/2003 14:05:06
I can search on:
Fields: 01, 02, 03, 2003, 14, 05, 06
Time: 14:05, 14:05:06, 05:06
M & D: 01-02

But I have not determined how to include the year. I have tried the
following without success:
01-02-03
01-02-2003
01-02-103
03-01-02
2003-01-02
103-01-02


Does anyone know of how to include the year for such a search?
Does someone the source available to see what format can be used?

Thanks