Current Date

[Guest]

In the query i am trying to pull date from today to end of month. What format
should i use for that?
Thank you

 

[Guest]

Try these --
Use Date() for today.
Use DateAdd("m",1,Date()-Day(Date()))

 

[Guest]

Some thing for this criteria i am doing wrong. Please tell me what is wrong?
Between Date() And DateAdd("m",1,Date()-Day(Date()))

 

[John Spencer]

Try

BETWEEN DATE() AND DATESERIAL(Year(Date()),Month(Date())+1,0)

 

[Guest]

Thank you, I will try this way.

Try

BETWEEN DATE() AND DATESERIAL(Year(Date()),Month(Date())+1,0)