| Subject | Re: [ib-support] Calling all SQL Gurus... |
|---|---|
| Author | Raymond Kennington |
| Post date | 2002-08-22T16:25:18Z |
Following on Martijn's idea, keep the data stored as you have and test
EncodeDate() is a UDF.
Raymond Kennington
> EncodeDate(H.Yr, H.Mo, 12) > '2001/08/01' and EncodeDate(H.Yr, H.Mo, 12) < '2002/07/01'where the day 12 and >, < need to be determined according to your needs and the
EncodeDate() is a UDF.
Raymond Kennington