BAQ date calc Vantage 8.03.403c

Yahoo Archive
1
If you want them all in different CALC fields, then:

YEAR
Year(ShopCap.LoadDate)
Format = >>>9
Data Type = Integer

MONTH
Month(ShopCap.LoadDate)
Format = >9
Data Type = Integer

WEEKDAY
WeekDay(ShopCap.LoadDate)
Format = 9
Data Type = Integer

Thanks
Patty Buechler

--- In vantage@yahoogroups.com, "bpbuechler" <pbuechler@...> wrote:
>
> Pick your Table & Field and create a CALC field within the BAQ as
> follows:
>
> YEARMONTH
> If (Month(OrderRel.NeedByDate) < 10) Then
> String(Year(OrderRel.NeedByDate)) + '/' + '0' + String(Month
> (OrderRel.NeedByDate))
> Else
> String(Year(OrderRel.NeedByDate)) + '/' + String(Month
> (OrderRel.NeedByDate))
>
> FORMAT = X(12)
> DATA TYPE = Character
>
> --------------OR---------------
>
> MONTHYEAR
> If (Month(OrderRel.NeedByDate) < 10) Then
> String(Year(OrderRel.NeedByDate)) + '/' + String(Month
> (OrderRel.NeedByDate))
> Else
> String(Year(OrderRel.NeedByDate)) + '/' + String(Month
> (OrderRel.NeedByDate))
>
> FORMAT = X(12)
> DATA TYPE = Character
>
> Thanks
> Patty Buechler
>
>
>
> --- In vantage@yahoogroups.com, "lapulsifer" <sharon.pulsifer@>
> wrote:
> >
> > Hello. I need some help with a BAQ date calculation. I found
some
> > Progress documentation on date calculations, but it appears to
> cover
> > only basic date functions. I was able to successfully calculate
> the
> > month, day, year and weekday of a date.
> >
> > Does anyone know how to calculate today() - 30?
> >
> > Thanks.
> >
>
2
Hello. I need some help with a BAQ date calculation. I found some
Progress documentation on date calculations, but it appears to cover
only basic date functions. I was able to successfully calculate the
month, day, year and weekday of a date.

Does anyone know how to calculate today() - 30?

Thanks.
3
Pick your Table & Field and create a CALC field within the BAQ as
follows:

YEARMONTH
If (Month(OrderRel.NeedByDate) < 10) Then
String(Year(OrderRel.NeedByDate)) + '/' + '0' + String(Month
(OrderRel.NeedByDate))
Else
String(Year(OrderRel.NeedByDate)) + '/' + String(Month
(OrderRel.NeedByDate))

FORMAT = X(12)
DATA TYPE = Character

--------------OR---------------

MONTHYEAR
If (Month(OrderRel.NeedByDate) < 10) Then
String(Year(OrderRel.NeedByDate)) + '/' + String(Month
(OrderRel.NeedByDate))
Else
String(Year(OrderRel.NeedByDate)) + '/' + String(Month
(OrderRel.NeedByDate))

FORMAT = X(12)
DATA TYPE = Character

Thanks
Patty Buechler



--- In vantage@yahoogroups.com, "lapulsifer" <sharon.pulsifer@...>
wrote:
>
> Hello. I need some help with a BAQ date calculation. I found some
> Progress documentation on date calculations, but it appears to
cover
> only basic date functions. I was able to successfully calculate
the
> month, day, year and weekday of a date.
>
> Does anyone know how to calculate today() - 30?
>
> Thanks.
>