time dsum and #

[wassimdaccache]

Dear all


What is the difference between

=nz(DSum("Invoiceamount","invoices","[customerid]=" & [CustomerID] & "and" & "[credit]= " & True  &  " and [invoicetime]<#" & [receipttime] & "#"),0)

and

=nz(DSum("Invoiceamount","invoices","[customerid]=" & [CustomerID] & "and" & "[credit]= " & True  &  " and [invoicetime]<" & [receipttime] & ""),0)

both function returned the same value but I need the accurate one. I am afraid in future to get different values.

What does the # really do ?

receipttime data type is date (long time).

Any comments would be appreciated.


THANK YOU IN ADVANCE


REGARDS

[missinglinq]

The pound sign tells Access that receipttime is defined as a DateTime DataType.

Linq ;0)>

[nico5038]

To get all info on date/time you should checkout:
The Access Web - Date/Time: Index of Articles

Nic;o)