Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Format {startdate} and or {instancestart} in saved search???
created a saved search which has a concat() formula which displays "Register" link in the saved search.
I appended {startdate} {starttime} {endtime} to the url to populate fields on the registration page. I can pass the data, but need to reformat the displayed values.
I have tried TO_CHAR() and TRUNC() with no luck
How can I format these fields to display
{startdate} need to return the date and not "one time event on"
{starttime} & {endtime} need to display the time with AM/PM
So my formula is text using concat() and 3 values I need to format the date due to how they display
0