That's what I was wondering, too. I've had this come up a few times, it's not that easy in some other translators. I'm wondering if this wouldn't be more appropriately handled within the ERP system. If so, this also would allow for adjustments due to temporary and fluctuating conditions such as bad weather, customs delays, road construction, etc.
Leah ________________________________ From: Samantha Scott <[email protected]> To: Chris Johnson <[email protected]> Cc: [email protected] Sent: Thursday, November 3, 2011 11:37 AM Subject: Re: [EDI-L] Logic to add business days/working days to any given date I doubt it knows about all your "bank holidays" over there. ;-) No, its just days. Each day of the week has a numeric value of course so you can, with some creativity, plan around weekends but you'd need to reference a standalone calendar table to take into consideration and custom "working" day schedule. On Nov 3, 2011, at 11:12 AM, Chris Johnson wrote: > Quoted text is from <[email protected]>, by > Samantha Scott <[email protected]> > > >#Mydate = #Mydate << days(5); That 5 can be any number, a variable > >that is numeric and even a negative. > > If you want to add 5 *working* days then will the "<<" operator take > into consideration weekends, regional public holidays, etc.? It is a > very clever operator if it does; those sorts of calculations can be > quite tricky. > > Regards > Chris > -- > Chris Johnson mobile:+44 (0)7785 302122 Fax: +44 (0)870 0519 818 > EDI website http://www.edimatrix.co.uk > EDIMatrix Ltd work: 0845 126 0680 or +44 20 8778 1402 > Registered in UK no. 2777624 Reg.Office: 34 Sydenham Rd, London SE26 5QF > [Non-text portions of this message have been removed] ------------------------------------ ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix.Yahoo! Groups Links [Non-text portions of this message have been removed] ------------------------------------ ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix.Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/EDI-L/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
