I meant all of the months in order. Thanks.
----- Original Message -----
From: "Adrian Overs" <[EMAIL PROTECTED]>
To: <u2-users@listserver.u2ug.org>
Sent: Monday, May 08, 2006 9:53 PM
Subject: Re: [U2] OPEN Statement DICT Default
> Solution to "puzzle" :
> Month = OCONV(DATE(),"DMBL")
> D = Date
> MB = Abbreviated Month Name
> L = Lower Case
>
>
> On 9/5/06 9:45 AM, "Mark Johnson" <[EMAIL PROTECTED]> wrote:
>
> > I specifically remember being taught
> > X=STR("0",5-LEN(X)):X
> > for the 00001 concept.
> > Before the % was allowed, a shorter form was
> > X=("00000":X)"R#5"
> > which I recall using until % came about.
> >
> > On that note, I stole "R-10" and "C#10" from UD and offered it to D3
> > hopefully for their next release.
> >
> > Thanks
> > Mark Johnson
> >
> > P.S. Many use OCONV(DATE(),"D2/")[7,2] for the month. I think DATE()"DM"
is
> > the shortest way.
> > Puzzle: Illustrate the simplest way to generate Jan thru Dec.
> >
> >
> > ----- Original Message -----
> > From: "Roger Glenfield" <[EMAIL PROTECTED]>
> > To: <u2-users@listserver.u2ug.org>
> > Sent: Monday, May 08, 2006 9:42 AM
> > Subject: Re: [U2] OPEN Statement DICT Default
> >
> >
> >> The same programmer that doesn't read the manual does an....
> >>
> >> EXECUTE instead of a SELECTINDEX, and yes, the index already
existed....
> >>
> >> or
> >> A=STR('0',20-LEN(B)):B
> >> instead of
> >> A=FMT(B,'L%20') or for the Universe Pick/Ideal flavor people in the
> >> crowd A= B'L%20'
> >>
> >> or
> >> TODAY=OCONV(DATE(),'D2/')
> >> CONVERT '/' TO @VM IN TODAY
> >> MONTH=TODAY<1,2>
> >> instead of
> >> MONTH=OCONV(DATE(),'DM')
> >>
> >> ----
> >> And yes, I have observed all of the above recently.
> >>
> >> ;) Just 15 minutes a week to look through the current manuals to find
> >> out about a new option that you might not know existed?
> >>
> >> Roger
> >>
> >> Louie Bergsagel wrote:
> >>> I've never used the null dict indicator. Who ever reads the syntax
book
> >>> unless a command doesn't work?
> >>>
> >>> *":)*
> >>> -- Louie Bergsagel
> >>>
> >>>
> >>> On 5/5/06, Mark Johnson <[EMAIL PROTECTED]> wrote:
> >>>
> >>>> To All:
> >>>>
> >>>> Was there ever a real requirement on any prior flavor to have the
> >>>> typically
> >>>> non-used DICT portion of the OPEN statement be the set of quotes and
a
> >>>> comma.
> >>>>
> >>>> I accidentally forgot it in 1978 on a Microdata and it still
compiled.
> > To
> >>>> this
> >>>> day I have not seen a reason for the OPEN "","FILE" null dict
indicator
> >>>> and
> >>>> have not used it since unless I actually want the DICT level.
> >>>>
> >>>> Just wondering.
> >>>>
> >>>> Thanks
> >>>> Mark Johnson
> >>>> -------
> >>>> u2-users mailing list
> >>>> u2-users@listserver.u2ug.org
> >>>> To unsubscribe please visit http://listserver.u2ug.org/
> >> -------
> >> u2-users mailing list
> >> u2-users@listserver.u2ug.org
> >> To unsubscribe please visit http://listserver.u2ug.org/
> > -------
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> >
>
> --
> Adrian Overs
> Phone : +61 (0)2 9484-7160
> Mobile: +61 (0)411 358 354
> -------
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
