Using DateCompare in SQL Query ???

[Markh51]

How do I use date compare in my SQL query's ??

I have tried:
...AND DateCompare(getDate(), lot.lotOpenDateTime) <> -1

but I just keep getting an error saying DateCompare is not a recognized function.

If I can use DateDiff in my querys why can't I use DateCompare. Am I doing something wrong ???

Thanks,
Mark

 

[NoWayIsThisInUse]

You left off pound signs around DateCompare... Don't know if you meant to or not, but that would certainly make a difference.

 

[Markh51]

I tried that. I then just says DateCompare is Undefined.

 

[Markh51]

BTW,

DateDiff work fine without the '#' signs.

Regards,
Mark

 

[r937]

you never mentioned which database you're using, mark

that's usually necessary to get the right answer to date function questions

but you left a clue -- getdate() suggests it's microsoft sql server


and datediff(day, lot.lotOpenDateTime, getdate()) <> -1


rudy

http://r937.com

 

[Markh51]

Thanks to all who replied, it is now all sorted.

Cheers,
Mark