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/
