Is there a way break out the seconds and milliseconds from a date time field in a formula field?
WHY:
I want our crew people to use check-in and check-out from their mobile device. However, if they forget to check in or don't have service, I need to give them the ability to manually override the time. I want the supervisor to be able to identify if the device did it vs end user. I can create a formula field that looks at milliseconds and if they are 0 then I would assume the date was modified manually.
Best Answer
The first part of the Griffin's answer is incorrect (should be
RIGHT
instead ofLEFT
).This formula will give you the seconds as a number. As Griffin's answer states, you must use apex if you need milliseconds.