Simple Date Code >6 for dteentered field

[burrina]

I can't think right now. I have a date field and need to check for dates >6 for this field dteentered. Do I simply put >6 in the query grid?
That is more than 6 days have elapsed since it was entered!

[June7]

No, must compare calculated date with the current date. The criteria under dteentered field would be:

< Date - 6

[ketbdnetbp]

burrina -

You could try...

> DateAdd("d",6,[dteentered])

All the best,

Jim

[ketbdnetbp]

Sorry, June7, didn't see your post before replying. Jim

[June7]

Is okay, made me review my post and provide additional comment.

Calculation of date values will default to day unit so no need for DateAdd function unless want some other unit like months or years.

[burrina]

Thanks, I appreciate it.