I can't set a filter on a date column. Using MSAccess.
1) Open the table
2) Activate the filter row
3) Type something like this: [DataEmissione] >= '2009-11-01'
4) Apply filter
The result is an error message (from DotNet I suppose because is in Italian)
'Tipi data non corrispondenti nell'espressione criterio' that means something like 'Type mismatch in criteria expression'
There is a particular syntax to follow using this types of values?
Thanks.
Hello, thank you for this
Hello,
thank you for this remark
Filter expression shoud look like [DataEmissione] >= #2009-11-01# (or in format #yyyy-mm-dd HH:MM:SS# for value with time)
DatAdmin support
Thanks, my mistake, the colum
Thanks, my mistake, the colum has a time part and I haven't typed it.
Post new comment