Show the time ONLY not the date also

When I select creation time it will show both the date and time. I only want to show the time portion. How would I do this?

+35

You would have to create another field — a formula field — that extracts the time from the date field. For example, something like this:

DATETIME_FORMAT({Date Field}, 'h:mm a’)

+29

You can do it all in one formula field. Use the CREATED_TIME() function to return the created date/time, and then format it to show only the time.

DATETIME_FORMAT(CREATED_TIME(), 'h:mm a')

You might also want to specify a time zone:

DATETIME_FORMAT(SET_TIMEZONE(CREATED_TIME(), 'Australia/Sydney'), 'h:mm a')

Sign up