[SalesForce] Get seconds and milliseconds from date/time in formula field

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 of LEFT).

This formula will give you the seconds as a number. As Griffin's answer states, you must use apex if you need milliseconds.

VALUE(
    LEFT(
        RIGHT(
            TEXT(now())
        ,3)
    ,2)
)
Related Topic