CHALLENGE! I need to convert the {shipdate} on a ...
# suitescriptd
darrenhillconsulting
04/23/2021, 6:28 PMCHALLENGE! I need to convert the {shipdate} on a transaction (in a search result field) to ISO8601 UTC date-time. Help!
b
battk
04/23/2021, 6:34 PMTO_CHAR(CAST({shipdate} AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD"T"HH24:MI:SS.FF3"Z"')🙏 1
a
alien4u
04/23/2021, 6:34 PMCAST({created} as timestamp with time zone) at time zone 'UTC'
alien4u
04/23/2021, 6:35 PM@darrenhillconsulting Looks like @battk response is more elaborated...
b
battk
04/23/2021, 6:35 PMsame basic idea, cast as a timestamp
battk
04/23/2021, 6:36 PMtimestamps have much better formatting options
d
darrenhillconsulting
04/23/2021, 6:36 PMBrilliant! @battk wins and can take the rest of the day off!
b
battk
04/23/2021, 6:37 PMdoes that mean you will answer all people by directing them to the help for me
d
darrenhillconsulting
04/23/2021, 6:38 PMCorrect. I'm working on a standard message right now
c
creece
04/23/2021, 6:38 PMSometimes you win at suiteanswers and sometimes you lose
d
darrenhillconsulting
04/23/2021, 6:39 PMlol. Hope all you guys are well and safe!
c
creece
04/23/2021, 6:41 PMI'mma keep that formula in my notes. I've never had to do what you're wanting but thats pretty handy.
3 Views