You need to sign in to do that
Don't have an account?
Vicki
Vicki
How to get Time from Date/Time field
Does anyone know how to extract the time from a date/time field?
I need to capture Time created so we can alert a team if a Case is created today before 3:30.
All their cases need to be closed same day created if created before 3:30 but I can't trap the date in order to send alerts on cases that are not closed at 5:00 if created before 3:30.
Any help would be appreciated.
Thanks,
Vicki
Here is a formula you may be able to build on:
RIGHT( TEXT( Date_Time__c ) , 10)
Note: The conversion of the date time field to text (which you must do to parse the right 10 characters)results in a 24 hour time Z. Meaning 11/21/2007 4:19 PM EST returns as 21:19:00Z