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 with Spaces between the Month Day and Year
EXAMPLE:
Current Code:
${check.trandate?string(“MM dd YYYY”)}
Current Output:
[![enter image description here][1]][1]
Expected Output:
[![enter image description here][2]][2]
So basically, I need to add spaces between the date characters.
I tried entering a space using the space button between like “M M D D Y Y Y Y”, the format gets messed up and shows the first number of the month, date, and puts year value 4 times like
[![enter image description here][1]][1]
Thanks in Advance!