You can, it really depends on what you are trying to do though. If you are simply trying to enter a static time with a date, it is fairly simple using the DATETIMEVALUE, the TEXT function and concatenating the static date on the end of a date. If you are trying to use dynamic times it can be a little more difficult, as converting data types and time zones then become a factor. I find it much easier to do something like this using apex personally, as it gets to be way to much of a hassle trying to do it with formulas and workflows, unless it is a single time you need.
You can, it really depends on what you are trying to do though. If you are simply trying to enter a static time with a date, it is fairly simple using the DATETIMEVALUE, the TEXT function and concatenating the static date on the end of a date. If you are trying to use dynamic times it can be a little more difficult, as converting data types and time zones then become a factor. I find it much easier to do something like this using apex personally, as it gets to be way to much of a hassle trying to do it with formulas and workflows, unless it is a single time you need.
Thanks, I found the DATETIMEVALUE function in the SF doc. Wonder why it does not display (the way that DATETIME does) in the list of available functions in the Advanced Function editor? Anyway, thanks again for your help.
You can, it really depends on what you are trying to do though. If you are simply trying to enter a static time with a date, it is fairly simple using the DATETIMEVALUE, the TEXT function and concatenating the static date on the end of a date. If you are trying to use dynamic times it can be a little more difficult, as converting data types and time zones then become a factor. I find it much easier to do something like this using apex personally, as it gets to be way to much of a hassle trying to do it with formulas and workflows, unless it is a single time you need.
--KC
All Answers
You can, it really depends on what you are trying to do though. If you are simply trying to enter a static time with a date, it is fairly simple using the DATETIMEVALUE, the TEXT function and concatenating the static date on the end of a date. If you are trying to use dynamic times it can be a little more difficult, as converting data types and time zones then become a factor. I find it much easier to do something like this using apex personally, as it gets to be way to much of a hassle trying to do it with formulas and workflows, unless it is a single time you need.
--KC
Thanks, I found the DATETIMEVALUE function in the SF doc. Wonder why it does not display (the way that DATETIME does) in the list of available functions in the Advanced Function editor? Anyway, thanks again for your help.