You need to sign in to do that
Don't have an account?
bhanu p
I Need to capture record created time into another field.
Ideally I'd store the hour in a formula field (10:23 = 10 and 3:49 = 13, etc.)
I Have a field like opportunity_hour, in this field i need to capture record created time into another field?
Ideally I'd store the hour in a formula field (10:09 = 10 and 3:36 = 15, etc.)
Thoughts on how best to do this?
Thanks,
I Have a field like opportunity_hour, in this field i need to capture record created time into another field?
Ideally I'd store the hour in a formula field (10:09 = 10 and 3:36 = 15, etc.)
Thoughts on how best to do this?
Thanks,
Check the following blog it will help you to extract hour from datetime field.
http://codewithajay.blogspot.in/2016/03/extension-to-datetime-formula-SFDC.html
You can also check these formulas :
http://resources.docs.salesforce.com/200/13/en-us/sfdc/pdf/salesforce_useful_formula_fields.pdf
Check page number 18
Regards,
Ajay
Please find the below formula to provide the time.
LEFT(RIGHT(text( CreatedDate ),9),2)
It will display in GMT time zone, you may need to convert it accordingly.
Regards,
Mahesh
Please refer to: https://help.salesforce.com/HTViewSolution?id=000181642&language=en_US
And try this:
This should automatically adjust to the timezone.
Thanks,
AG