You need to sign in to do that
Don't have an account?
Text Formula to include DATE/TIME
I need a Text Formula to include the formatted DATE/TIME as part of the text string. Just as the DATE/TIME fields are formatted for the user time zone, I would like to do this within a Text Formula.
e.g.
"Some text can come from other places, then we also show the date 20/12/2009 12:48 PM"
I am stuck on how to format the Date/Time fields in the correct format within a Text Formula. My 1st formula to work with the date alone (in a Text Formula) was long enough, I dread to think what is needed to format the date as above. I am hoping there is something very simple I have missed. Or should I just write a trigger?
You could try something like this (read all the way to the bottom)
https://sites.secure.force.com/answers/ideaView?c=09a30000000D9y3&id=087300000007Y7C&returnUrl=/apex/ideaList%3Fc%3D09a30000000D9y3%26p%3D2%26sort%3Dpopular%26status%3DAnswered