Date Format

[pradeepkrao]

Hi,

My system dateformat is mm/dd/yyyy.

Dim strSql as String
 
strSql = txtDate.Text ' mm/dd/yyyy format 03/04/2003
 
strSql = "select * from items where item_dt = #" & Format(strSql,"mm/dd/yyyy") &"#"
 
MsgBox strSql
 
' The above shows 
' select * from items where item_dt = #04/03/2003#

Can anybody please suggest me what format to use and how to go about such problems..

Thanks,
Pradeep

[PilgrimPete]

You could try this:

strSql = "select * from items where item_dt = #" & Format(strSql,"dd mmmm yyyy") &"#"