I am looking to capture the Date/Time so that I can use it in a Case report. Currently, our team is only able to report on the Date and not the time that a case was opened. I was thinking that I can capture this by stamping a custom field via a Workflow rule witht eh Created Date and Time, but I want to make sure it captures time from our default locale/timezone (pacific).
I've seen a few formula fields flying around but not sure which to use.
Thank you!!
3 respostas
Hi Brittney, You can create a Time field with a default value as
TIMENOW()
However, if it takes 5 minutes to save the record after clicking New, this will mean that the time will be 5 minutes before the created date.
If this is for reporting reasons only, you can create a formula Time field that you can report on and use
TIMEVALUE(CreatedDate)
