Date changes within BPM

Ignore the last email - all sorted

Thanks for the messages.


--- In vantage@yahoogroups.com, "roomurray" <rupert@...> wrote:
>
> That works TYVM - but only seems to work on line 1. On line numbers 2+ the value is null
>
>
> --- In vantage@yahoogroups.com, "netrippers" <netrippers@> wrote:
> >
> > Progress has an add-interval function to manipulate dates.
> >
> > Try Assign orderhed.date01 = ADD-INTERVAL(orderhed.created, 60, 'Days') The second parameter can be positive or negative. The third parameter is 'Days', 'Months' or 'Years'.
> >
> > Tom
> >
> > --- In vantage@yahoogroups.com, "roomurray" <rupert@> wrote:
> > >
> > > Thanks David,
> > >
> > > I've done similar, but what I need to achieve is to set other fields to calculated values. For instance when in the order entry screen
> > >
> > >
> > > orderhed.date01 = orderhed.created + 60 etc
> > >
> > > --- In vantage@yahoogroups.com, "Dave Pfiester" <dpfiester@> wrote:
> > > >
> > > > --- In vantage@yahoogroups.com, "roomurray" <rupert@> wrote:
> > > > >
> > > > > I'm looking to update date fields within BPM(s).
> > > > >
> > > > > What I need to do is take a date like today or a date already in a field and add a specific days/weeks/Months to that value and return it to a new date field.
> > > > >
> > > > > I've tried all sorts, but nothing has worked.
> > > > >
> > > >
> > > > I have not tried doing a date change in a BPM, but I have done it in a BAQ calculated field. I used the following formula to add 60 days to a date:
> > > >
> > > > Date(ShipHead.ShipDate) + 60
> > > >
> > > > David
> > > >
> > >
> >
>
I'm looking to update date fields within BPM(s).

What I need to do is take a date like today or a date already in a field and add a specific days/weeks/Months to that value and return it to a new date field.

I've tried all sorts, but nothing has worked.
--- In vantage@yahoogroups.com, "roomurray" <rupert@...> wrote:
>
> I'm looking to update date fields within BPM(s).
>
> What I need to do is take a date like today or a date already in a field and add a specific days/weeks/Months to that value and return it to a new date field.
>
> I've tried all sorts, but nothing has worked.
>

I have not tried doing a date change in a BPM, but I have done it in a BAQ calculated field. I used the following formula to add 60 days to a date:

Date(ShipHead.ShipDate) + 60

David
Thanks David,

I've done similar, but what I need to achieve is to set other fields to calculated values. For instance when in the order entry screen


orderhed.date01 = orderhed.created + 60 etc

--- In vantage@yahoogroups.com, "Dave Pfiester" <dpfiester@...> wrote:
>
> --- In vantage@yahoogroups.com, "roomurray" <rupert@> wrote:
> >
> > I'm looking to update date fields within BPM(s).
> >
> > What I need to do is take a date like today or a date already in a field and add a specific days/weeks/Months to that value and return it to a new date field.
> >
> > I've tried all sorts, but nothing has worked.
> >
>
> I have not tried doing a date change in a BPM, but I have done it in a BAQ calculated field. I used the following formula to add 60 days to a date:
>
> Date(ShipHead.ShipDate) + 60
>
> David
>
find first ttOrderDtl where ttOrderDtl.RowMod = 'U' or

ttOrderDtl.RowMod = 'A' no-lock.

if available ttOrderDtl then do:

assign ttOrderDtl.Date02 = TODAY.

end.



This is a sample of 4GL code we use on a massive customization that sets a
date filed. I'm sure there are other option other than "TODAY" that you can
use. TODAY + 30 or something of this nature.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Dave Pfiester
Sent: Wednesday, May 06, 2009 8:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Date changes within BPM








--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"roomurray" <rupert@...> wrote:
>
> I'm looking to update date fields within BPM(s).
>
> What I need to do is take a date like today or a date already in a field
and add a specific days/weeks/Months to that value and return it to a new
date field.
>
> I've tried all sorts, but nothing has worked.
>

I have not tried doing a date change in a BPM, but I have done it in a BAQ
calculated field. I used the following formula to add 60 days to a date:

Date(ShipHead.ShipDate) + 60

David





[Non-text portions of this message have been removed]
Progress has an add-interval function to manipulate dates.

Try Assign orderhed.date01 = ADD-INTERVAL(orderhed.created, 60, 'Days') The second parameter can be positive or negative. The third parameter is 'Days', 'Months' or 'Years'.

Tom

--- In vantage@yahoogroups.com, "roomurray" <rupert@...> wrote:
>
> Thanks David,
>
> I've done similar, but what I need to achieve is to set other fields to calculated values. For instance when in the order entry screen
>
>
> orderhed.date01 = orderhed.created + 60 etc
>
> --- In vantage@yahoogroups.com, "Dave Pfiester" <dpfiester@> wrote:
> >
> > --- In vantage@yahoogroups.com, "roomurray" <rupert@> wrote:
> > >
> > > I'm looking to update date fields within BPM(s).
> > >
> > > What I need to do is take a date like today or a date already in a field and add a specific days/weeks/Months to that value and return it to a new date field.
> > >
> > > I've tried all sorts, but nothing has worked.
> > >
> >
> > I have not tried doing a date change in a BPM, but I have done it in a BAQ calculated field. I used the following formula to add 60 days to a date:
> >
> > Date(ShipHead.ShipDate) + 60
> >
> > David
> >
>
That works TYVM - but only seems to work on line 1. On line numbers 2+ the value is null


--- In vantage@yahoogroups.com, "netrippers" <netrippers@...> wrote:
>
> Progress has an add-interval function to manipulate dates.
>
> Try Assign orderhed.date01 = ADD-INTERVAL(orderhed.created, 60, 'Days') The second parameter can be positive or negative. The third parameter is 'Days', 'Months' or 'Years'.
>
> Tom
>
> --- In vantage@yahoogroups.com, "roomurray" <rupert@> wrote:
> >
> > Thanks David,
> >
> > I've done similar, but what I need to achieve is to set other fields to calculated values. For instance when in the order entry screen
> >
> >
> > orderhed.date01 = orderhed.created + 60 etc
> >
> > --- In vantage@yahoogroups.com, "Dave Pfiester" <dpfiester@> wrote:
> > >
> > > --- In vantage@yahoogroups.com, "roomurray" <rupert@> wrote:
> > > >
> > > > I'm looking to update date fields within BPM(s).
> > > >
> > > > What I need to do is take a date like today or a date already in a field and add a specific days/weeks/Months to that value and return it to a new date field.
> > > >
> > > > I've tried all sorts, but nothing has worked.
> > > >
> > >
> > > I have not tried doing a date change in a BPM, but I have done it in a BAQ calculated field. I used the following formula to add 60 days to a date:
> > >
> > > Date(ShipHead.ShipDate) + 60
> > >
> > > David
> > >
> >
>