Compile error

[primerov]

Compile error

The following constant is wrongly made by me, and i get "Compile error" :

Public Const CnstUpdate as Date > #01/01/2003#

May i get some help?
I wanted to insert the constant into the following line:

StrCustomers = " SELECT customers.* INTO CustomersTemp FROM customers

WHERE Customers.LastUpdated > #01/01/2003#"

 

[parkville]

When declaring constant, you set its value using equals.

But if it is a constant, why not embed value in StrCustomers
as in your post - it should work.

However, if it can vary, use:
Public VarUpdate As Date
VarUpdate = #01/01/2003#
StrCustomers = " SELECT customers.* INTO CustomersTemp FROM customers
WHERE Customers.LastUpdated > #" & Format(VarUpdate, "mm/dd/yyyy&quot & "#"