CODEWITHSUNDEEP
datetimenetsuite
Travis
Travis

Reputation: 2245

Netsuite 24 hour clock in formula(text)

I am looking for the proper syntax for the 24 clock in a formula(text) in a NetSuite saved search.

Here is a sample of what i am using that output the 12 hour clock...

TO_CHAR({datecreated},'MM/DD/YYYY HH:MI:SS')

And example output for this would be 12/31/2014 01:25:11

I would like the output to be 12/31/2014 13:25:11

Thanks in advance!

Upvotes: 0

Views: 1077

Answers (1)

Travis
Travis

Reputation: 2245

If anyone else finds this and needs to correct syntax it is 

TO_CHAR({datecreated},'MM/DD/YYYY HH24:MI:SS')

Upvotes: 1

Related Questions