You need to sign in to do that
Don't have an account?
sieb4me
daylight time change
Hi,
I have following formulla in my assignment rule, which works fine. But now due to daylight time change here in USA, I need to make change.
What would be the new formulla for it?
Thanks
AND(
(VALUE(MID(TEXT(NOW()),12,2)) >= 16), /* BusinessHourStart: 16:00 UTC */
(VALUE(MID(TEXT(NOW()),12,2)) < 24)
),
AND(
(VALUE(MID(TEXT(NOW()),12,2)) >= 00),
(VALUE(MID(TEXT(NOW()),12,2)) < 01) /* BusinessHourStop: 01:00 UTC */
)
)
)
I have following formulla in my assignment rule, which works fine. But now due to daylight time change here in USA, I need to make change.
What would be the new formulla for it?
Thanks
AND(
(VALUE(MID(TEXT(NOW()),12,2)) >= 16), /* BusinessHourStart: 16:00 UTC */
(VALUE(MID(TEXT(NOW()),12,2)) < 24)
),
AND(
(VALUE(MID(TEXT(NOW()),12,2)) >= 00),
(VALUE(MID(TEXT(NOW()),12,2)) < 01) /* BusinessHourStop: 01:00 UTC */
)
)
)
Please refer to this post:
http://salesforce.stackexchange.com/questions/9633/time-zone-and-daylight-savings-calculations-to-a-text-field
Thanks,
Pratik
P.S. If this answers you question, please mark it as "Best Answer" so it will help other community members too.