Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Need Date And Item value Formula Help - Suggestions?
Anyone out there have any advice for this formula I need? NetSuite says they got this formula to work, but it does not. I am getting killed by the limitations on formula characters and have had to resort to all kinds of tweaks just to get the formula under 3000 characters.
Basically, I have a NetSuite item that I need to assign a value to depending on when it was sold. So if item1 was sold between 07/01/13 and 10/15/13, then it is worth 100. If it was sold between 10/16/2013 and 12/31/2013, it is worth 150. I have 16+ items with prices that change every quarter, which leads to a lengthy formula. I would greatly appreciate any advice. I cannot even get the formula below to work - it might be a syntax error.