DataView.RowFilter

[Guest]

I have a Table wicth as the Field: Date in the Date/Time format and stores
data like dd-MM-yyyy hh:mm:ss.
I can I set the Dataview.Rowfilter to filteran especific date no mathers the
Time?

I've tryed several ways Me.DataView1.RowFilter=Date='#17-10-2005 %#'.

Thanks in advance

Luis

 

[Cor Ligthert [MVP]]

Luis,

Date times are not stored in databases as SQL server and Access in the
format dd-MM-yyyy hh:mm:ss pm/am. The IDE shows dates (in the current
versions) only in USA format and not in the format of the rest of the world.
The used format are ticks (even different units) from a certain date in
past. For you is that is moment mostly important if you are not working
centuries back.

There is as well a datetime literal. ##MM:dd:yyyy# That is as well (in the
current versions) only to use in USA format. That does normally not matter
because you can use almost everywhere ISO format by new
DateTime(yyyy,MM,dd,hh,mm.ss)

However not in the expression. In the literal (as you showed) in an
expressions do you have (at the moment) to use the USA formats as well.

I hope that this gives a more general idea about datetime.

Cor