You need to sign in to do that
Don't have an account?
kirubakaran viswanathan
How to split UTC datetime to Date and time based on Country in Opportunity
I have the start and end DateTime field in Opportunity, I need to split that into date and time based on customers' country in the record.
Eg: UTC : 2021-04-26T09:00:00.000+0000
Country is UK
Output:
Date : 26-04-2021
Time : 10 AM
If the country is Germany
Output:
Date : 26-04-2021
Time : 11 AM
Eg: UTC : 2021-04-26T09:00:00.000+0000
Country is UK
Output:
Date : 26-04-2021
Time : 10 AM
If the country is Germany
Output:
Date : 26-04-2021
Time : 11 AM
You can make use of the FORMAT() that converts and displays a given datetime into user's locale
Example: I am passing val in UTC and it returns in IST timezone
If this information helps, please mark the answer as best. Thank you
Related: https://developer.salesforce.com/forums/?id=906F000000098DmIAI
Thanks