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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Formula(date/time)
I'm trying to write a formula for the date.
GROUP {trandate}
12/9/2013
12/10/2013
12/11/2013
12/12/2013
i want it to look like this, if {trandate} matches {today} i want to add the time at the end. so that they know this report for 12/12/2013 isn't the complete day.
12/9/2013
12/10/2013
12/11/2013
12/12/2013 10:00AM (grab today's time)
Formula(Numeric)
CASE WHEN to_char({trandate},'MM/DD/YYYY')=to_char({today},'MM/DD/YYYY') THEN to_char({today},'MM/DD/YYYY HH:MI') ELSE to_char({trandate},'MM/DD/YYYY') END
It's not recognizing 'MM/DD/YY HH:MI'
a formula something like this, but mine doesn't work.
0