You did mean
OCONV(DATE(),"D2/")[1,2] for month, at least in the Western Hemisphere
and [4,2] for the Eastern, right? ;-)
Roger
Mark Johnson 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.
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
