Create a submit date that doesn't change

[sboyd]

I have a form that is submitting both to a database and SharePoint
Document Library. Once submitted to the database, another user will
pull the form up in SharePoint to make changes and resubmit back to
the database.

I have the SharePoint name generated by a concatenation of a
AddedToTable Date which I have set to Now() and an ID field. I
need the date not to change after it is first submitted but my date
keeps changing. How can I get the initial date not to change so that
my SharePoint document name doesn't change? I want any changes within
the form saved back to the same document.

I've searched the forums and I can't find what I need. I need a
solution that doesn't require code.

Thanks

 

[littleccguy]

I am not an expert at programming or databases, but it sounds like the
database is allowing an UPDATE on the date field.

Example: I have a form used for employees records. I create the
employee and the date as you have it enters using Now(). If I have to
come back in six months and change the last name because the employee
got married, the date in relation to the employee is now today and not
six months ago - is that right?

Are the employees actually changing the form, or pulling up a record
and editing the record. If the later is true, maybe the database
needs to add a new record every time there is a change in order to
keep history. ???

Is that making sense?

 

[sboyd]

I am not an expert at programming or databases, but it sounds like the
database is allowing an UPDATE on the date field.

Example: I have a form used for employees records.  I create the
employee and the date as you have it enters using Now().  If I have to
come back in six months and change the last name because the employee
got married, the date in relation to the employee is now today and not
six months ago - is that right?

Are the employees actually changing the form, or pulling up a record
and editing the record.  If the later is true, maybe the database
needs to add a new record every time there is a change in order to
keep history. ???

Is that making sense?

I didn't want any new records. Another user offered me the solution
by adding a new field making it the value of the date field once the
form is opened and added a rule that if the field was blank to set
that value. That way the next time the form was opened, it already
had a date and therefore would not change. It worked great. Thanks
for your comment to my post.

 

[littleccguy]

that was a great idea