2006-07-28 00:00:00

This is the result I get in Word as I handle a document that merges data
from the database. The field «Date_Fin_Membre» returns me this result
even if the query stipulates
WHERE (dbo.Membre.Date_Fin_Membre = CONVERT(Char(10),
dbo.Membre.Date_Fin_Membre, 101)). I have also tried other types of
conversion without any success. I just need the date not the following
hours, minutes and seconds.
thanksYou might be using CONVERT(Char(10), dbo.Membre.Date_Fin_Membre, 101)
only for checking in where clause, you will have to specify the same in
Select columns as well.
something like this:
Select
CONVERT(Char(10), dbo.Membre.Date_Fin_Membre, 101) from XYZTable
Where
dbo.Membre.Date_Fin_Membre = CONVERT(Char(10),
dbo.Membre.Date_Fin_Membre, 101))
Regards,