Something like SUBSTR({zipcode}, 1, (LENGTH({zipcode}-3)) Hey JCirocco That worked a treat, very slight tweak to order: SUBSTR({zipcode}, 1, (LENGTH({zipcode})-3)) Thanks a lot.

Hello, Sorry for the delay in response. Just thought I'd let you know this works perfectly now thanks to your formula. Not sure why I didn't think to try the IS Statement. Cheers

Hello, I am trying Find the difference between a customers first purchase date and last purchase date. I am trying to achieve this using a transaction search that looks at all sales orders which are closed. In the results I then have 'date closed' twice, one that has the minimum date and the other shows a maximum date. Is…

Good to know we're not alone, Stability has been a real issue over the last month or 2.

Anyone else suddenly getting timeout's/poor performance again?!

[h=2]RECENT POSTS[/h] 2/7/2017 A datacenter-wide incident in our EU Central facility has resulted in a degradation in performance for customers local to that datacenter when attempting to access accounting functionality. Operations Engineers were notified of the issue by monitoring and are working to resolve it as quickly…

I haven't tried editing products but performance certainly does seem terrible today. We do have an error coming up when trying to attach PDF's to invoices using the advanced PDF/HTML templates. I've had to revert all our Transactions forms back to simple PDF's for now. Also when trying to attach something to an email from…

Hmm, it was supposed to be an embedded pic of the https://status.netsuite.com/status_en_US.html

Oh Dear....

It's been fine all week (since the issues last Thurs/Friday), but today we just seem to be getting random bouts of slow page loads. It then seems fine for a bit and then someone else shouts out...

We're down now?!

Is anyone else seeing horrible performance since 3PM UTC? We're nearly at a stand still!

Just an FYI, it seems that one of the NetSuite sending IP's is currently on a Spamhaus Blacklist. Defect #- 252154 SUMMARY: Spamhaus Block: [167.216.129.170] blocked by Spamhaus-ZEN

Hi both, I had wondered, thanks confirming. I'm not our scripting guy here so I'll see what they say :) Thanks Mike

Hello, I've just started to play with workflows too and whilst the example on help is very easy i can't seem to create one that completely different. I'm trying to set a workflow up that will 'Close' all scheduled calls when a Lead becomes a prospect. It'd be perfect if i could remove only the phone calls in certain sales…