Search results for query: *

Yes it is working thanks!

edit* I changed the 7,6 to 8,6 and 6,6 to 7,6 if {table.order} = "batch" then x := mid({table.string},8,6) else {table.order} = "work order" then x := mid({table.string},7,6);

LBass, First of thanks for the response. I used your formula and I was returning some incorrect data. I was getting the wrong 6 digits. When I changed your formula to the one below it seems to be working. Do you know why this is? Also when I add the "date(2000+val..." ect ect string I get the...

I put the ones as a sample as follows. 1 = six or seven digits depending on the order (batches = 6 digit work orders = 7) 2 = six digit date that i want to single out 3 = 3 or 4 digits depending on the order sample data 2184796012511003

Hi all, I have a string (lot number) that is unique for each item we produce. One constant is the date but it can vary in it's location. I would like to trim out the extra numbers before and after and leave just the date. example data below. 1111111222222333 (this is the string some of the...

I am still lost here. I need to display my units used for this month and also display my units used for last month, and so on. I can display this month with no problem using a parameter field to select this month and this year but how can I also show last month's units used and two months ago...

Hi, First post so please be easy on me. I am trying to pull information on items with this month's info, last month, 2 months ago, this month last year, and next month last year. The problem is my date is saved in two seperate fields in my db; {month} and {year} and I do not know how to...