Query string to get MTD - Tonth To Date

[AT76]

Hello,

Is there a way to set a parameter in a column with dates to get only the Month to Date records?

Thanks!

 

[traingamer]

One way:

Between (Date()-Day(Date())+1) And (Date())

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[AT76]

Very cool. Is there a way to use function date() in a pass-thru querie?

 

[JerryKlmns]

Perhaps

WHERE DateField=Date()

 

[PHV]

use function date() in a pass-thru querie
Use the native RDBMS syntax ...