How to compare two dates in DS format SQL.SMALLDATETIME

snassimr · Post by **snassimr** » Thu Jun 02, 2005 7:33 am

I want ot compare to dates 1999/01/02 and 2000/01/02 and the answer that i get is wrong

ArndW · Post by **ArndW** » Thu Jun 02, 2005 7:41 am

snassimr,

please explain how you are comparing them? If you do a "1999/02/02" = "2000/01/02" you are going to a get a 0 {wrong}. What are you trying to compare - their equality? Days between?

snassimr · Post by **snassimr** » Thu Jun 02, 2005 7:47 am

I want to get that '2000/01/01' is greater (later) then '1999/01/01'

ArndW · Post by **ArndW** » Thu Jun 02, 2005 8:06 am

Since the format is yyyy/mm/dd you can do a simple string comparison, so your result of doing a ( '2000/01/01' > '1999/01/01' ) will return true. What is the condition you are testing - so that we might see why you state that it is wrong...

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jun 02, 2005 8:21 am

Make sure the format is yyyy/mm/dd. Also check you have 4 digit year.

amsh76 · Post by **amsh76** » Thu Jun 02, 2005 9:55 am

Or you can convert them in DS internal format and then do the comparison.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 02, 2005 4:03 pm

Or you can use the Compare() function and enforce left-justified comparison of the original strings. Make sure that each has the same delimiter character.