Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
AE:How to convert GMT to Malaysia time zone
Dear Experts,
I have to convert the PRF's approver date/time (GMT) format to GMT+8 for malaysia date/time zone,
-----------------------------------------------------------------------------------------------
I found the formula from https://jcurvesolutions1.zendesk.com/hc/en-us/articles/360035138071-Convert-Date-Created-Field-Time-Zone-to-a-Different-Time-Zone-on-a-Saved-Search as below :
To convert the Time Zone to a different one, use the sample below on saved searches:
1. Add Formula (Text) field under Results tab
2. Formula = to_char(new_time({datecreated}, 'GMT', 'EST'),'MM/DD/YY HH:MI AM')
The formula above converts the Date Created value to Eastern Standard Time and sets the format to MM/DD/YY HH:MI AM
--------------------------------------------------------------
I customized a sublist saved search in approver list