lace6921

HELP!!!! I am building a Macro to run in ERP (probably the most complex macro ever written in my world and will change procurement forever). It will create a Sales Order and create a Purchase Order. T30 Sales order Date (ex: 06152008) T31 Purchase Order Date (ex: 06202008) Where I am running into trouble is when the Sales Order Date (T30) is less than the Purchase Order Date (T31). If the Sales Order Date (T30) is less than the Purchase Order Date (T31) I need the Sales Order date (T30) to calculate the %T31% and add 7 days and then input the date in the system. Example. T30 Sales Order Date = 06152008 T31 Purchase Order Date = 06202008 Basically 06152008 is less than 06202008. So I need the macro to add 7 days and put a new value of 06272008 into the sales order. How do I get the macro to add the 7 days. I have an If variable %T30% <= %T31% statement. But for the life of me cannot figure out how to get Macro Express to add the seven days to the date for the Purchase Order (T31) Can anyone share any insight or wisdom. Suggestions or hints are more than welcome. Thanks Leslie

As you can see, I am recording some of the T values to the log. I also need the value on the clipboard. Any suggestions? Leslie <LOGFILE:NY:C:\Documents and Settings\lau5749\Desktop\ERP Macro\4 ERROR Purchase Order Advice.txt%T1% %T5%>

Jason, I really appreciate your response. I have one more issue though  Now my issue is the ‘A’, which is variable from a screen from a system. How do I capture the variable and then compare it to the %T1% and use the If / Then Statement? I have a Get Control %C1% and want to compare that to the %T1% use the If / Then Statement. ASCII File Begin Process: "TestFile" (Comma Delimited Text ) If Variable %T1% = "A" Variable Set String %T99% "%T2% %T3% %T4%" Clipboard Append Text: "LogFile,txt" End If If Variable %T1% <> "A" Variable Set String %T99% "%T2% %T3% %T4%" Clipboard Append Text: "ErrorLog,txt" End If ASCII File End Process Thank you so much. Leslie

I am trying to create what I think is a simple macro I want it to compare the information I have in a text file to the information from an application. Basically If ‘A’ does not ‘A’ Log the information into a txt file (basically an error report) and then move onto the next value in the text file. I am completely lost with the if then statements. This is just a portion of the macro I am using!!! Let me know if you need more information, of course this blog thing is new to me also. Please help! Thanks Leslie