Queries with the Now() function

[theduke32]

I'm playing with the queryNew() function to create my own pseudo-database, and filling it with some information including a date. Using the createODBCDate() function to do this, I know that I am being returned a valid date. What I am ultimately trying to do is return from my query all results that had yesterday's date. I tried using the dateAdd() function and subtracting 1 day, but I can't get anything returned for the query. I can't get anything returned from the query at all, though it's not giving me an error. What do I do?

 

[TruthInSatire]

What do I do?

post your existing code.

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.

 

[theduke32]

i actually figured it out. i had to format the date i created in my database using dateFormat() as well as query using the dateFormat() function. tempermental thing...
thanks!