You need to sign in to do that
Don't have an account?

local time zone
Hi,
this is my formula field ( CASE(CASE(BillingState ,
'BC', 1,
'CA', 1,
'NV', 1,
'OR', 1,
'WA', 1,
'YT', 1,
'AB', 2,
'AZ', 2,
'CO', 2,
'ID', 2,
'MT', 2,
'NM', 2,
'UT', 2,
'WY', 2,
'AL', 3,
'AR', 3,
'IL', 3,
'IA', 3,
'KS', 3,
'LA', 3,
'MB', 3,
'MN', 3,
'MS', 3,
'MO', 3,
'NE', 3,
'ND', 3,
'OK', 3,
'SD', 3,
'SK', 3,
'WI', 3,
'CT', 4,
'DE', 4,
'GA', 4,
'ME', 4,
'MD', 4,
'MA', 4,
'MI', 4,
'NH', 4,
'NJ', 4,
'NY', 4,
'NC', 4,
'OH', 4,
'ON', 4,
'PA', 4,
'QC', 4,
'RI', 4,
'SC', 4,
'VT', 4,
'VA', 4,
'WV', 4,
'AK', 5,
'HI', 6,
'FL', IF(MID(Phone,2,3) = "850",3,4),
'IN', IF(MID(Phone,2,3) = "219",3,4),
'KY', IF(MID(Phone,2,3) = "270",3,4),
'TX', IF(MID(Phone,2,3) = "915",2,3),
'TN', CASE(MID(Phone,2,3),"865",4,"423",3,0),
0),
1,-8,
2,-7,
3,-6,
4,-5,
5,-9,
6,-10,
0))
the result it was displaying was 8,7 for example
but i want the output as GMT-8
Please suggest me the modifications
Thanks & Regards
Pratyusha.K
this is my formula field ( CASE(CASE(BillingState ,
'BC', 1,
'CA', 1,
'NV', 1,
'OR', 1,
'WA', 1,
'YT', 1,
'AB', 2,
'AZ', 2,
'CO', 2,
'ID', 2,
'MT', 2,
'NM', 2,
'UT', 2,
'WY', 2,
'AL', 3,
'AR', 3,
'IL', 3,
'IA', 3,
'KS', 3,
'LA', 3,
'MB', 3,
'MN', 3,
'MS', 3,
'MO', 3,
'NE', 3,
'ND', 3,
'OK', 3,
'SD', 3,
'SK', 3,
'WI', 3,
'CT', 4,
'DE', 4,
'GA', 4,
'ME', 4,
'MD', 4,
'MA', 4,
'MI', 4,
'NH', 4,
'NJ', 4,
'NY', 4,
'NC', 4,
'OH', 4,
'ON', 4,
'PA', 4,
'QC', 4,
'RI', 4,
'SC', 4,
'VT', 4,
'VA', 4,
'WV', 4,
'AK', 5,
'HI', 6,
'FL', IF(MID(Phone,2,3) = "850",3,4),
'IN', IF(MID(Phone,2,3) = "219",3,4),
'KY', IF(MID(Phone,2,3) = "270",3,4),
'TX', IF(MID(Phone,2,3) = "915",2,3),
'TN', CASE(MID(Phone,2,3),"865",4,"423",3,0),
0),
1,-8,
2,-7,
3,-6,
4,-5,
5,-9,
6,-10,
0))
the result it was displaying was 8,7 for example
but i want the output as GMT-8
Please suggest me the modifications
Thanks & Regards
Pratyusha.K
Please check with below link from forums community with same issue and suggested workaround.
- https://developer.salesforce.com/forums/?id=906F0000000BatLIAS
- http://www.craigrjordan.com/salesforce/create-a-timezone-formula-in-salesforce/
Please let us know if this helps.Regards,
Nagendra.