Date in Query is switching from day/mont to mont/date kneed help... 2

[jben2u]

this is the query

SELECT tblTypeStatut.TypeStatut, tblSuivi.RVID
FROM tblSuivi INNER JOIN tblTypeStatut ON tblSuivi.StatutTypeID = tblTypeStatut.StatutTypeID
WHERE (((tblSuivi.RVID)=197) AND ((tblSuivi.DateStamp)=#01/09/2004 9:3:44#));

the problem is that #01/09/2004 9:3:44# ends up looking like this #09/01/2004 9:03:44 AM# as you can see ther is a problem,...

 

[cmmrfrds]

What you are seeing is the DEFAULT display format. The date is stored the same in the database, as a decimal number, regardless of the format used to enter or display the date.

Use the Format function to display the way you want.

Format(tblSuivi.DateStamp,"dd/mm/yyyy")

 

[TCARPENTER]

Try Format([DateStamp], "dd/mm/yyyy hh:mm:ss")

HTH
Todd

 

[jben2u]

thank you both for your help....