Use the below formulas to extract time from a Date-Time field in a saved search
Formula(Text) – TO_CHAR({datecreated}, ‘HH:MI:SS’)
Formula(Text) - TO_CHAR({datecreated},'MM/DD/YYYY HH:MI:SS AM')
Note:
- Always make sure formula type matches the value you are returning. For example, Formate (Date) and Formula (Datetime) is not the same.
- When converting to Date, value will be returned in Date Format you have set in your personal preference. For example, if your NetSuite personal preference setting is set to show dates in MM/DD/YYYY format, even if you ran TO_DATE(’16-11-2016′,’DD-MM-YYYY’) as your formula, value will show as 11/16/201