2

Formula field to display current time based on the Company's default time zone, does anybody have the idea how to achieve this

For User's timeZone current time used the NOW() - but don't know how to find for company's Time Zone

Improve this question

1 Answer 1

Reset to default
3

Unfortunately, the default Org Timezone is not available in the $Organization.xxx merge fields. Nor, incidentally, is it available on the Organization Object

Thus, to make this available to formulas, you will need to use a hierarchical custom setting field Default_Org_TZ__c , set its value at the org-level in the UI editor so all running users will always have this value available.

Then you'll need to compare the running user's TZ offset versus the custom setting value and adjust NOW() accordingly. See tip

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .