No; I don't believe there are any NetSuite time-re...
# suitescripte
erictgrubaugh
04/05/2019, 3:17 PMNo; I don't believe there are any NetSuite time-related fields that store any resolution other than minutes
r
rfollmer
04/05/2019, 3:18 PMOk. Thank you!
b
battk
04/05/2019, 4:11 PMif you really need to, NetSuite stores the fields with second precision
battk
04/05/2019, 4:11 PMyou can get at it using a formula in a search column
battk
04/05/2019, 4:11 PMfor example:
battk
04/05/2019, 4:11 PMTO_CHAR({lastmodifieddate}, 'DS TS')battk
04/05/2019, 4:14 PMbe careful of timezones. I never figured out how to get timezone information in there, or how to turn it into a unix timestamp
r
rfollmer
04/05/2019, 4:28 PM@battk this is my current formula for “Last Modified UTC” in a saved search:
Copy code
SYS_EXTRACT_UTC(TO_TIMESTAMP_TZ(TO_CHAR({lastmodifieddate},'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS TZH:TZM'))b
battk
04/05/2019, 4:36 PMYou are unlucky
r
rfollmer
04/05/2019, 4:37 PMwhat the eff? 😂
rfollmer
04/05/2019, 4:38 PMdid you define formula (datetime) or formula (text)? for the “your thing” column
b
battk
04/05/2019, 4:38 PMtext
r
rfollmer
04/05/2019, 4:39 PMOH wow.. thats the difference
rfollmer
04/05/2019, 4:39 PMchanging to formula(text), I can get
2016-10-24 01:40:34.0rfollmer
04/05/2019, 4:44 PMThank you @battk
3 Views