I have setup a series of custom forms for the add form, modify form, delete form etc etc. How do you insert the Add Date into the corresponding db.

In DBMan I remember using &get_date but when I use that in DBManSQL it does not seem to work?

I have set the field type to DATE in the properties and when the autogenerate forms were used the proper date was added. So far have tried putting &get_date in the default field, <%&get_date%> and all other combination in the template with no luck.

Suggestions

Thanks in advance

Christian