How to search a dates earlier than January 1, 1753

[Zyronne]

Hello Experts.

I have a database that deals with history. Since MSSQL 2000 cannot accept dates earlier than Jan 1, 1753 I converted my column to CHAR.

My problem now is I cannot find dates on a Range..If supposing my datatype is DATETIME, I would use DATE1 BETWEEN STARTDATE AND ENDDATE.


Thank you in advance.

[hariharanmca]

Hello Experts.

I have a database that deals with history. Since MSSQL 2000 cannot accept dates earlier than Jan 1, 1753 I converted my column to CHAR.

My problem now is I cannot find dates on a Range..If supposing my datatype is DATETIME, I would use DATE1 BETWEEN STARTDATE AND ENDDATE.


Thank you in advance.

you can use where clause like

where DateField >= '<FromDateValue>' and DateField >= '<ToDateValue>'

[astanton]

you can use where clause like

where DateField >= '<FromDateValue>' and DateField >= '<ToDateValue>'

The important thing when using this is to cast or convert the date in the correct char/varchar format. YYYYMMDD HHMMSS will let you use the between comparison above.

You may have to stuff a leading zero into months and days (and years) that are not comprised of the full 4 digits.