Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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.