Languages

Filter on date columns

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

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options