WHERE end_date = month(date()) + 3

  • Thread starter Thread starter marco_pb via AccessMonster.com
  • Start date Start date
M

marco_pb via AccessMonster.com

I am really sorry if there was a posting about this before..
I do not search for the forum, as it is urgent. I am chasing the deadline..

I am really sorry for my bad English as well. I hope somebody can help me..
Thank you all in advance.

here goes the problem,
I would like to have an overview of trainees who will end their training time
3 months after today.
can the criteria be: WHERE end_date = month(date()) + 3 ??

I am really a noob in MS Access 2003 (access 2000 format). I really
appreciate your helps. Thank you
 
where end_date = dateserial(year(date()),month(date())+3,day(date()))

(david)
 
Thank you very much David...
It works.. I really thank you for your help..
thank you..

Have a nice day..
where end_date = dateserial(year(date()),month(date())+3,day(date()))

(david)
I am really sorry if there was a posting about this before..
I do not search for the forum, as it is urgent. I am chasing the
Click to expand...
[quoted text clipped - 12 lines]
I am really a noob in MS Access 2003 (access 2000 format). I really
appreciate your helps. Thank you
Click to expand...
Click to expand...
 
here goes the problem,
I would like to have an overview of trainees who will end their training time
3 months after today.
can the criteria be: WHERE end_date = month(date()) + 3 ??
Click to expand...

David's suggestion is fine, but an alternative somewhat shorter one
is

WHERE end_data = DateAdd("m", 3, Date())

John W. Vinson[MVP]
 
Thank you John.

I really thank you for the answer.. I'm sorry to reply this long, because I
have to catch up with the deadline

have a nice day.. ^^
 
Back
Top