These calculations were set up before me, and I don't know exactly how they are calculated. It appears to be some deritivitive of a 24 hour day.
What I would like to do is build new calculations that provide the Denver start time for a specified time zone and takes daylight savings into account. What makes this even trickier is that the output needs to be a date/time field - not text.
Any suggestions would be helpful. We need to add several additional time zones for our events team and I don't know how to go about doing this.
3 respuestas
Hi Brent,
Can you add a little more context to your need? If you have a field for Start Time & End Time, these are entered by a user in Denver, if your users are in another time zone and have their correct time zone set in their User's detail page, it should convert to the time zone for the User. I don't think there is a need to calculate daylight savings into the date/time field, but if you need to, there are formulas out there for it.
If you are looking to just make new fields to show the time in a specific time zone, (for example three date time fields, one displaying Denver Start Time, one stating East Coast Start Time, and one West Coast Start Time), then you would need to create a formula field, and if you google this you'll see that there are formulas for it (which are based off of 24 hours) and then you'd calculate Daylight Savings as a separate field for each time zone and then calculate that into the formula field.
If you can provide more information, I'll get back to this answer later today. Also if you can paste the current formula for whatever field, that would be helpful. I'm assuming it is based off of something like this https://help.salesforce.com/apex/HTViewSolution?id=000005091&language=en_US .
-Stephen
