PDA

View Full Version : WAS Field rule? date entry


ABC123

Peter.Greulich
01-01-2006, 11:39 PM
I would like my date field filled with the current date when entering a new record. I'm totally at a loss.

Hansolo
01-02-2006, 04:19 PM
I would like my date field filled with the current date when entering a new record. I'm totally at a loss.

Peter- I have a database field that tracks the date a record is created or updated. The simple implementation I am using is to create a calculated field. The Calculated field expression is SYSTEM->DATE.

When a new record is created the current system date (your server is the current system) is entered into this field. If the record is edited in any field the calculated data field is updated as well.

This way you never have to display the field except for viewing or reporting the record as needed.

Chuck

Peter.Greulich
01-02-2006, 04:33 PM
Thanks, Chuck.

I want the date the record was entered, but not changed.

I'll probably try this:


If(alltrim(cdate(Date)) = "",Date(),Date)