How to cature creation date?

vikki

Hi,

I just want to know is it possible to capture the creation date for a customer/vendor, unlike keeping a field in customer table entering the data while creating a customer

ssingla

You can use the standard functionality of Change Log to keep a track of modification/insert/delete for the customer table.

Savatage

Adding a "Creation Date" field is quite easy, in fact it still boggles my mind why this 1 simple field isn't standard for Vendor, Customer, Item, etc.

For example on the customer table put on the
No.-OnValidate() trigger

"Creation Date" := WORKDATE;

With "Creation Date" being a date type field that you add to the customer table. With this little code the date is automatically filled in, no manual entry needed.

The same goes true for the other tables you might use it in.