jhoover

Thanks for the welcome and the script. I thought about doing something like this but wasn't sure how to implement it. I do have a couple of problems though. If the Date + 6 winds up on the first of the month, and it also happens to be one of the days from the IF statements, it winds up trying to add "-1" days and freaks out a bit. This happens next monday, the 25th. I also use a similar chunk of code to put in the month using the down arrow. I guess I should do something like IF %N1% > 25 THEN %N2% = %N2% + 1 Where N1 is the date, and N2 is the number of the month. Though this would pose problems because some months have 31 days and if the conditions are right, I'd end up scheduling a month + 5 business days, and because of February having only 28, I'd end up a month behind since it wouldn't start changing over the month on the 23rd. I suppose there could be an IF statement for Feb, an IF statement for months with 30 days, and an IF statement for months that have 31. Just seems needlessly complex when all it took was {down {date +4r "d"}} in KeyText. Granted, ME is FAR more advanced than KT ever thought about being, and the added flexibility is nice. Thanks for your help, I'll see if I can work out some solutions.

First, I guess I should say that I've been using KeyText as my macro editor for a while now, but I'm having all kinds of problems since upgrading to XP, so I figured I'd give MacroExpress a try. The way that I do this in KeyText is to use the command {down {Date+4r "d"}}. Here's where I am with the ME code: <DT:dT:01:3:{F00004}{P00000}{P00000}{P00000}><TMVAR2:05:01:01:000:000:><REP3:05:000001:000001:0001:0:01:><TEXTTYPE:<DOWN ARROW>><ENDREP><REP3:01:000001:000001:00006:0:01:><TEXTTYPE:<TAB>><ENDREP><DD{NF005}{P000}01><TMVAR2:05:01:01:000:000:><REP3:05:000001:000001:0001:0:01:><TEXTTYPE:<DOWN ARROW>><ENDREP> Is there a way, when manipulating the date, to add days, but only business days (Monday thru Friday)? Basically, I have a form that has a "due date" on it. It should always be 5 business days (including today as day 1) from today. I want to have the date + 5 days pass to a variable, convert the variable to numeric, and use it to run a loop to push the down arrow "date+5" times. I am able to do this no problem with just 5 days, but for example, today is Wednesday, so 5 business days from today would be next Tues, the 26th, but instead it will give me next Sunday, the 24th. This won't work since it would basically give only 3 days to work on it. Anyone have any idea how to do this? Thanks, John Hoover john.hoover@us.ing.com