[donald7]

Hi all,
Would very much appreciate your help.

I am trying to use the date entered on a Windows Screen (using the DateTimePicker) in an SQL query. Anyone know the format to reference the date field???

Thanks

[FirstBorn]

If You're using an Access Database:

"Select * from [TableName] Where [DateFieldName] = #" & Format(dtpicker1.Value,"YYYY/MM/DD) & "#"

Don't know exactly what you're trying to do with your query, but this should work for the format.

I hope this helps!

[donald7]

Thanks, I'll try it.