
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 10, 2020 04:00 PM
As you can expect, I am using a function field to manipulate a time field;
two issues appeared
- gmt zone went crazy inside the new form field
- language for dates now are shown in english.
Two solutions came to rescue:
-
For issue # 1 I can use:
DATETIME_FORMAT(SET_TIMEZONE({date field}, 'America/Bogota'), 'dddd, MMM D, YYYY h:mm a')
-
for issue #2 I can use:
DATETIME_FORMAT(SET_LOCALE({date field}, 'es'), 'dddd, MMM D, YYYY h:mm a')
They both work perfectly INDIVIDUALLY,
How can I combine these 2 formats inside one single formula.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 10, 2020 04:13 PM
Welcome to the community, @Lewis_Sternberg!
You can use this formula:
DATETIME_FORMAT(SET_LOCALE(SET_TIMEZONE({date field}, 'America/Bogota'),'es'),'dddd, MMM D, YYYY h:mm a')

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 10, 2020 04:13 PM
Welcome to the community, @Lewis_Sternberg!
You can use this formula:
DATETIME_FORMAT(SET_LOCALE(SET_TIMEZONE({date field}, 'America/Bogota'),'es'),'dddd, MMM D, YYYY h:mm a')

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 10, 2020 04:20 PM
Fantastic !
Couldn’t find a sample before asking the community.
Thanx for the help.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 10, 2020 04:22 PM
Glad I could help! :slightly_smiling_face: If you don’t mind, could you please mark my comment above as the solution to your question? This will help other people who have a similar question in the future. :slightly_smiling_face:
