Display list w/ today's date only

[mgifford]

I need to create a select statement where the only things listed are where the date field matches today's date only.

What else do I need?

sSQL="Select * from PRObs Where [Date] = ??????How do I only display the current date match??????

 

[SkipVought]

sSQL="Select * from PRObs Where [Date] = Date()

Skip,
[sub]
[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM! [/sub]

 

[mgifford]

THANK YOU, THANK YOU, THANK YOU!!!! I knew it was something simple but couldn't find an example of it in any of my other pages or books. BLESS YOU!!!

 

[SkipVought]

I'd be careful about using RESERVE WORDS as field and variable names.

DATE is a reserve word!

Skip,
[sub]
[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM! [/sub]

 

[mgifford]

Thanks for the tip! Still learning new things everyday!