Date Format

[PilgrimPete]

You could try this:

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