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!
SQL formula to look at month
OK...... I've been racking my brain over this.
I created a search that sum's an amount based on when a purchase order is supposed to ship. The problem is that when I compare it to the month it is not giving me the {item.cost}, I get 0 every time.
Anyone have any idea's what I'm doing wrong?
I have created a generic field to_char({custbody_ship_date},'MONTH') and confirmed that the system is returning the MONTH from the ship date
But when I do the comparison to_char({custbody_ship_date},'MONTH') = 'DECEMBER' I do not get any results, just 0