+ Start a Discussion

Is there a way to identify time of day within a formula or workflow?

I am trying to automate the selection of a picklist value based upon the time of day that a user enters a record.  I would like to do this without having to write APEX code.  Is there a way within a formula to identify the time as part of the date/time value to use as criteria?


Thanks.  Mike Edwards.  www.saasmaint.com

Best Answer chosen by Admin (Salesforce Developers) 

Sorry man, I don't think so.  The set of functions that work with datetimes are very few.  What you'd need is to be able to create a datetime that represents midnight of the day in your source datetime field (and then to subtract the midnight datetime from your source), but I don't think there's any way to do that in the formula language, only in Apex.