Hi,
You can use the below logic to implement your requirement.
Here ACT_DAY is the actual date provided by partner.
Sdateofyear = #Field_String;
dateformat = new ("java.text.SimpleDateFormat","yyyyMMdd");
ID = dateformat.parse(Sdateofyear);
Sdayofyear = ID.getDay();
if Sdayofyear = 0 then
BUSINESS_DAY = ACT_DAY <<days(5);
else
if Sdayofyear = 1 then
BUSINESS_DAY = ACT_DAY <<days(7);
else
if Sdayofyear = 2 then
BUSINESS_DAY = ACT_DAY <<days(7);
else
if Sdayofyear = 3 then
BUSINESS_DAY = ACT_DAY <<days(7);
else
if Sdayofyear = 4 then
BUSINESS_DAY = ACT_DAY <<days(7);
else
if Sdayofyear = 5 then
BUSINESS_DAY = ACT_DAY <<days(7);
else
if Sdayofyear = 6 then
BUSINESS_DAY = ACT_DAY <<days(6);
--
Thanks,
Makesh Elangovan
+91-8970051116
On Thu, Nov 3, 2011 at 9:57 PM, Trina Brada <[email protected]> wrote:
> **
>
>
> You need to work on getting the requested delivery date adjusted by 5 days
> so that your open PO's are aligned with your supplier's order board.
>
> You really want your suppliers to deliver 5 days later than the MRP system
> is expecting and planning on receiving?? That will throw off your
> production plan.
>
>
> [Non-text portions of this message have been removed]
>
>
>
[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/
