G
GGill
In the query i am trying to pull date from today to end of month. What format
should i use for that?
Thank you
should i use for that?
Thank you
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
KARL DEWEY
Try these --
Use Date() for today.
Use DateAdd("m",1,Date()-Day(Date()))
Use Date() for today.
Use DateAdd("m",1,Date()-Day(Date()))
G
GGill
Some thing for this criteria i am doing wrong. Please tell me what is wrong?
Between Date() And DateAdd("m",1,Date()-Day(Date()))
Between Date() And DateAdd("m",1,Date()-Day(Date()))
J
John Spencer
Try
BETWEEN DATE() AND DATESERIAL(Year(Date()),Month(Date())+1,0)
BETWEEN DATE() AND DATESERIAL(Year(Date()),Month(Date())+1,0)
G
GGill
Thank you, I will try this way.
John Spencer said:Try
BETWEEN DATE() AND DATESERIAL(Year(Date()),Month(Date())+1,0)