How do I create a field with today's Date?
This can be done through a view:
Here is an example where
Sample is the ViewName, Orders is a table in the database, and CurrentDate is the field
Create view Sample as
select
getdate() as CurrentDate
from Orders
Go