more discoveries:i actually have two forms that use this date field - the first one works fine and is an update page
UPDATE DISTINCTROW
business
SET dateupdated='::dateupdated::'
WHERE ID=::ID::
where dateupdated = a hidden field <%Date()%>
The page that does not see to work looks like this:
INSERT INTO business (dateupdated)
VALUES ('::dateupdated::')
where dateupdated is has the same hidden field value.
btw above i think i talked about the variable dateadded - while here i talk about dateupdated - please overlook this
still conFused
...any ideas ?