How to skip last 3 digit in the data?

[#1]

Hi QV Team,

I need to skip the last 3 digits. Help me out.

[tresesco · Accepted solution]

Left(Field,Len(Field)-3)

[amit_saini]

Hi,

Like this???

Thanks,

AS

[#4]

Hi Murali,

Please try this,

Mid(Sales Order#,1,( Len(Sales Order#)-3))

Warm Regards,

Joshmi

[#5]

thank you.