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.
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