You can insert the date a new entry is made in your SQL server table by simply adding a DateCreated column, setting the type to Date/Time and entering getdate() into the default value field.
When you updating a record this getdate() will not work, but you can simply add a hidden field in your form, called it say txtupdatedon and set the value to <% =day(now) %>/<% =month(now) %>/<% =year(now) %>
I am not sure what you mean by Date duration..maybe you could expand on this..?
Comments
Dates
When you updating a record this getdate() will not work, but you can simply add a hidden field in your form, called it say txtupdatedon and set the value to <% =day(now) %>/<% =month(now) %>/<% =year(now) %>
I am not sure what you mean by Date duration..maybe you could expand on this..?
Date search
You must me logged in to write a comment.