"Record made" and "record changed" date/time problem

[juuser]

Hi,

I have two "regular" date fields (not jdate):
1) Record made date/time - ("Default to current date")
2) Record changed date/time - ("Default to current date" and "Always return today's date")

As the names say, first one is to determine when record is created and second one when it is changed.

When creating the new record, both of these dates/times should be identical. Anyhow first of these elements takes the date/time when the new record form is opened and the second takes the date/time when the record is submitted.

Therefore I cannot determine anymore has the record been altered or the time difference is just the time between opening and submitting a form.

Is there any solution for this problem?

Thanks!

 

[juuser]

Friendly bump

 

[cheesegrits]

The only thing I can suggest is setting the ACL on the 'edit' one so nobody has 'new' access, so (I think) un-edited records would have an edit date of 0000-00-00, or maybe null.

-- hugh

 

[juuser]

Thanks! Seems that I already have access of the elements on form "add" and "edit" set to "no-one" (access level with no groups), so these cannot be changed by the user, but they still seem to be creating the date, not 0000-00-00 or null.

If there is no other solution, I thought of form php plugin where I would set some field value to "1" on edit. Not too elegant and a lots of work for the existing tables, but should do the trick.