You need to sign in to do that
Don't have an account?
Mike_E
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
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.