Need 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

 

[S.Y.M. Wong-A-Ton]

It is not clear to me how your form has been set up, but what you could do is
maintain a separate field that is populated with something (anything) when
the form is submitted. Then you can use a rule and condition to prevent the
date field to be updated if that separate field has already been populated.