Recent content by itguymike

ran it with the new code and it showed 2 items only. the exp dates of the product that showed was 7/15/14

i want to use a static date range on a exp date report for products. i have the following: {TRACE.EXPIRATION_DATE} in (CurrentDate) to (CurrentDate+14) when i add it to the report i get only no records. if i create a parameter for a date range and use that instead it gives me pages of...

i have the statement below that is giving me a total amount of days a product has left until it is past it's expiration day. works great for all locations that are labeled short dated, here is the question, is also puts a '0' for the days left to exp on other location for example Quarantine...

thank you for getting back to me, looks like it worked perfectly, will check it to make sure, thank you again.

I have 1000 products with each one having up to 10 locations for that part. i am looking to show only parts with a qty that is in either QCHOLD, QUARANTINE or SHORTDATED or where there is no qty (out of stock) in any location for that part. Any ideas how to go about this. started with what is...

Yes it does, thank you very much

i am trying to create a static date range for a report.. basically i want any {PURCHASE_ORDER.DESIRED_RECV_DATE} dates that are 3 days before the currentdate to 14 days in he future. any help would be appreciated

we are trying to update the operation types for all operation.resource_id=' qc testing', when we run the script below it updates all resources besides the the "qc testing" resource. UPDATE OPERATION SET OPERATION_TYPE='QC TEST (TYPE1)',SETUP_HRS= '0', RUN_TYPE= 'HRS/LOAD', LOAD_SIZE_QTY=...

got it all worked out, thanks for all

THANKS, re ran the sql statment an got an error: invalid objetc name OPERATION CODE: UPDATE OPERATION SET OPERATION_TYPE='QC TEST (2+118)',SETUP_HRS= '0', RUN_TYPE= 'HRS/LOAD', LOAD_SIZE_QTY= '10000', RUN_HRS= '2', MOVE_HRS= '118', MINIMUM_MOVE_QTY= '', SETUP_COST_PER_HR = '0'...

I am trying to use 2 tables to update date: UPDATE OPERATION SET OPERATION_TYPE='QC TEST (2+118)',SETUP_HRS= '0', RUN_TYPE= 'HRS/LOAD', LOAD_SIZE_QTY= '10000', RUN_HRS= '2', MOVE_HRS= '118', MINIMUM_MOVE_QTY= '', SETUP_COST_PER_HR = '0', RUN_COST_PER_HR= '25', RUN_COST_PER_UNIT= '0'...

perfect, thank you.

hello, i am trying to update a time field in a table and am having issues. what i am trying to have happen is to update any desired_rls_date fields to be 2/18/2014 that are equal to or before the date below (2/18/2014) UPDATE WORK_ORDER SET DESIRED_RLS_DATE='2/18/2014' WHERE DESIRED_RLS_DATE...

oh geeze, thank you

i want to show only Purchase orders for last year and am drawing a blank on it. {PURCHASE_ORDER.ORDER_DATE}= year (2013) then says it wants a date