Follw up date

[Xzibit7]

I've got a query that returns values of items past a follow up date entered by a user with a calender in the query criteria I have <Date() so it should show all follow up dates past the current date. The problem is it does not return this. Is using the calender causing this due to a different format in the date() function perhaps?

 

[genomon]

Not a whole lotta info; if you want to return something PAST a date you might want to do > #datSomeDate# ?
<Date() will return everything BEFORE today....

I have great faith in fools; self-confidence my friends call it.
-Poe

 

[lespaul]

double posting - see Thread701-1263607 for more info.....

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi