Extract Time From Date field

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… Continue reading Extract Time From Date field