Access date

[Shirker]

I'm trying to tech myself Access 2010 as we need to get a better system for controlling mountains of health data the existing system is creaking now. I want to do a query which says sort all the people who have a test coming due within the next six months of today's date. Anyone know what the format for that would be? Something using =date () plus some time period?

Ta muchly.

[samhs]

select * from yourtable where datediff('d',now(),renewaldate)<184 order by renewaldate

That assumes you have a datetime column called renewaldate, and that your table is called yourtable, and that you're willing to accept 183 days as an approximation of 6 months.

hth

[Shirker]

Thanks Sam

[Rosco]

I think datedif() also takes 'm' (for month) as an argument, so you could be more exact in months