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!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Help with a DECODE statement using a date comparison
I am trying to look for a date in a specific position within a string. I attempted to use the following code:
DECODE(SUBSTR({outofstockmessage},51,10), {custitem_vendor_ship_date}, 0,1)So what I am doing is taking the 10 characters starting at position 51 in the string and looking to see if it is a date. (Then compare it to another date).
- If there is a date in that position properly formatted - It Works! (and there was much rejoicing)
- If there are no characters in the string at that position - It Works! (and there was much rejoicing)
- If there are characters there, but not in a date format...FAILURE! (Oh the shame)
0