Jazyky

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.

Poslat nový komentář

  • Webové a e-mailové adresy jsou automaticky převedeny na odkazy.
  • Povolené HTML značky: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Řádky a odstavce se zalomí automaticky.

Více informací o možnostech formátování