anyone good with formulas, trying to convert text 11/22/2017 32014 PM to a date using TO_DATE({custrecord_sh_apwf_startdate},‘MM/DD/YYYY HHMISS AM’) but it only converts the date portion not the time 11/22/2017 … any ideas?