getDate()

[ldoodle]

Hiya,

WHERE intAbsID NOT IN ('429','9170') AND dteDate = getDate()
Why does getDate() not show records matching today's date? If I hard code it as dteDate = '28/04/2009' it works.

Also, if I set a variable:

dteToday = Date()
then use:

WHERE intAbsID NOT IN ('429','9170') AND dteDate = '" & dteToday & "'
it works.

Have I misunderstood getDate()?

[pollymac]

getDate() returns both the time and the date.

[ldoodle]

Yes figured that out now.

Had to convert getDate() to only include the date.