On Jbase with different values to TODAY:
OCONV(TODAY, 'D2-') =
04-24-12
OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') =
12424 no
OCONV(DATE(),"D2YMD":@VM:"MCN") =
12 no
OCONV(TODAY,'DYMD') =
2012 no
OCONV(TODAY, 'DYMD[4"",2"",2]') =
2012 no
CONVERT(" ", "", OCONV(TODAY, "DYMD2")) =
2012 no
OCONV(TODAY,'DY2')'R%2':OCONV(TODAY,'DM')'R%2':OCONV(TODAY,'DD')'R%2' =
120424 yes
OCONV(TODAY, 'D2-') =
01-01-12
OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') =
1211 no
OCONV(DATE(),"D2YMD":@VM:"MCN") =
12 no
OCONV(TODAY,'DYMD') =
2012 no
OCONV(TODAY, 'DYMD[4"",2"",2]') =
2012 no
CONVERT(" ", "", OCONV(TODAY, "DYMD2")) =
2012 no
OCONV(TODAY,'DY2')'R%2':OCONV(TODAY,'DM')'R%2':OCONV(TODAY,'DD')'R%2' =
120101 yes
OCONV(TODAY, 'D2-') =
12-12-12
OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') =
121212 yes
OCONV(DATE(),"D2YMD":@VM:"MCN") =
12 no
OCONV(TODAY,'DYMD') =
2012 no
OCONV(TODAY, 'DYMD[4"",2"",2]') =
2012 no
CONVERT(" ", "", OCONV(TODAY, "DYMD2")) =
2012 no
OCONV(TODAY,'DY2')'R%2':OCONV(TODAY,'DM')'R%2':OCONV(TODAY,'DD')'R%2' =
121212 yes
I don't know about other implementation, but I think
OCONV(TODAY,'DY2')'R%2':OCONV(TODAY,'DM')'R%2':OCONV(TODAY,'DD')'R%2'
would work anywhere.
Charlie Noah
Tiny Bear's Wild Bird Store
"Everything For The Backyard Bird Enthusiast, Except For The Birds"
Info, Forum: http://www.TinyBearMarketing.com
Store: http://Stores.TinyBearMarketing.com
Toll Free: 1-855-TinyBear (855-846-9232)
On 04-24-2012 7:01 PM, David A. Green wrote:
I use: YYMMDD = CONVERT(" ", "", OCONV(TODAY, "DYMD2"))
David A. Green
(480) 813-1725
DAG Consulting
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Wjhonson
Sent: Tuesday, April 24, 2012 4:52 PM
To: [email protected]
Subject: [U2] YYMMDD easy way?
YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD')
easier way to do this?
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
