Capture two different System Dates

[SalientAnimal]

Hi All,

 

Yes I'm becoming a frequent poster... Hope I get my voyager miles  .

 

Ok but on a more serious note, I'm hoping to get some direction on this. I have a form that submits to the tables in the database. It is capturing the system date in a field named sys_date. At a later stage this task is updated by an user with an administrator function, I would like that when the administrator does the update a new system date is captured, keeping the existing one. The reason I want to do this is so that I can track turn around times.

 

Can anyone give me an idea of how to do this?

[requinix]

So if you want to keep the existing one, where is the new one supposed to go?

[Jessica]

You need a date_created and a date_modified field.

[SalientAnimal]

Yip, I have a column in the table which is the sys_date and then I have a date_modified.

 

I just need to know how would I get the date_modified to populate in the form update without the administrator being able to modify/minipulate this date. Basically the modified date must also be a system generated date.

[xyph]

Are you looking for a database-specific solution?

 

MySQL:

 

UPDATE tablename SET col1 = 'value', col2 = 'foobar', date_modified = NOW() WHERE orderid = '12345'

[SalientAnimal]

Thanks Xyph, that was exactly what I was looking for. Strange how sometimes you can do the impossible but the easy stuff you forget or plain and simply just don't think about it .