number signs in AdoTable.Filter

AdoTable1.Filter:= 'Date = #'+FormatDateTime('dd/mm/yyyy', Tomo开发者_如何学JAVArrow)+ ' #' ;

Why is Date surrounded with number signs?? Is this Access -specific??

thanks in advance!

DrStrangeLove, the # sign (hash-marks) is the delimiter for a date field in access, you can check this paper for more info about delimiters in Access.

Access Basics for Programming: Delimiters