This is a date calculation, sort of, but it might give you some ideas.. this is run in a BAQ.
(IF RcvDtl.ReceiptDate >= PORel.DueDate - 3 and RcvDtl.ReceiptDate <=
PORel.DueDate + 3
THEN "On Time"
Else (if RcvDtl.ReceiptDate < PORel.DueDate - 3
Then "Early"
Else (if RcvDtl.ReceiptDate > PORel.DueDate + 3
Then "Late"
Else "")))
Thanks,
Kunal
________________________________
From: liss_c <lissette.contreras@...>
To: vantage@yahoogroups.com
Sent: Wed, January 20, 2010 5:05:36 PM
Subject: [Vantage] Date Calculation using 4GL/BPM
I am creating a post-processing BPM that will update the ttJobMtl.date01 for each material added with the date calculated with the (ttJobOper.DueDate - ttJobMtl.LeadTime) .
I am a newbie at writing 4GL codes. I will appreciate if someone has created something similar to guide me on this task.
Thanks,
Lissette Contreras
KEC
Corona,CA
[Non-text portions of this message have been removed]
(IF RcvDtl.ReceiptDate >= PORel.DueDate - 3 and RcvDtl.ReceiptDate <=
PORel.DueDate + 3
THEN "On Time"
Else (if RcvDtl.ReceiptDate < PORel.DueDate - 3
Then "Early"
Else (if RcvDtl.ReceiptDate > PORel.DueDate + 3
Then "Late"
Else "")))
Thanks,
Kunal
________________________________
From: liss_c <lissette.contreras@...>
To: vantage@yahoogroups.com
Sent: Wed, January 20, 2010 5:05:36 PM
Subject: [Vantage] Date Calculation using 4GL/BPM
I am creating a post-processing BPM that will update the ttJobMtl.date01 for each material added with the date calculated with the (ttJobOper.DueDate - ttJobMtl.LeadTime) .
I am a newbie at writing 4GL codes. I will appreciate if someone has created something similar to guide me on this task.
Thanks,
Lissette Contreras
KEC
Corona,CA
[Non-text portions of this message have been removed]