So I have a field that shows the date created, but sometimes I need to change that date cause I use to for a time I send a W/O to a vendor.
basically I am using a date created formula to show the time I send a ticket to a vendor, but sometimes an associate will select the wrong vendor. I need a way to make the date created field to have a calendar pull down so I can change the date.
Is that possible?
Just create a field called [Date Created Override] as a date field.
Then make a formula for the [Date Sent to Vendor] as
IF(not isnull([Date Created Override]), [Date Created Override], ToDate([Date Created]))
It was not 100% clear in my mind if you were looking to capture the time of day as well as the date. I assumed just the date.
Then set up a formula date field called [Date Sent to vendor] with the formula I suggested.