How to change date to a pretty date - UV
Dawn Wolthuis
Martin Phillips
Dawn,
Conversion code D4DMAYL should do the job if your MV system supports it.
Martin
From: mvd...@googlegroups.com <mvd...@googlegroups.com>
On Behalf Of Dawn Wolthuis
Sent: 14 December 2021 17:22
To: mvd...@googlegroups.com
Subject: [mvdbms] How to change date to a pretty date - UV
|
EXTERNAL EMAIL |
--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+un...@googlegroups.com
For more options, visit
http://groups.google.com/group/mvdbms
---
You received this message because you are subscribed to the Google Groups "Pick and MultiValue Databases" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
mvdbms+un...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/mvdbms/CANKEuc6Sv_xK%3DdxzRHKrAy%3DXgEJA2k7%3D2%3DNqo1xVoBAq4w0_cw%40mail.gmail.com.
================================
Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA 02451 ■ Main Office Toll Free Number: +1 855.577.4323
Contact Customer Support: https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport
Unsubscribe from Marketing Messages/Manage Your Subscription Preferences - http://www.rocketsoftware.com/manage-your-email-preferences
Privacy Policy - http://www.rocketsoftware.com/company/legal/privacy-policy
================================
This communication and any attachments may contain confidential information of Rocket Software, Inc. All unauthorized use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify Rocket Software immediately and destroy
all copies of this communication. Thank you.
Steve Trimble
MONTH.NAME = OCONV(VAR$,"DMA") ; * alphabetic month
MONTH.DAY = OCONV(VAR$,"DD") ; * numeric day of month
MONTH.YEAR = OCONV(VAR$,"DY") ; * numeric year of month
CRT \cur.date \:OCONV(MONTH.NAME,"MCT"):" ":MONTH.DAY:", ":MONTH.YEAR
--
Dawn Wolthuis
To view this discussion on the web visit https://groups.google.com/d/msgid/mvdbms/CAJDLGm7tXuum9jDnhwHG%2BRS2-dwqh-GdF84pzuztP_HXGwmxRg%40mail.gmail.com.
Martin Phillips
Hi Dawn,
If you want the comma, try
D4MADYL[,”, ”]
Noting that the string in double quotes is comma space.
Martin
From: mvd...@googlegroups.com <mvd...@googlegroups.com>
On Behalf Of Dawn Wolthuis
Sent: 14 December 2021 19:10
To: mvd...@googlegroups.com
Subject: Re: [mvdbms] How to change date to a pretty date - UV
|
EXTERNAL EMAIL |
Thanks Martin and Steve!
I got almost all the way there with a variation of Martin's -- D4MADYL but don't know how/if the comma can get in there.
I'm helping a customer, and in this case, while I could create a virtual field with a subroutine, that would be in another category (requiring deployment of new metadata when I can put an OCONV into our xsl docs on the front-end without a "customization/$")
So, almost there, sans comma, and one of either Martin's
12 December 2021
or the alternative
December 12 2021
might be OK for the customer. If anyone knows how to get that comma in there with the OCONV sans subroutine, I would be interested. Aside from that THANKS A BUNCH! --Dawn
On Tue, Dec 14, 2021 at 1:03 PM Steve Trimble <cdm...@gmail.com> wrote:
Dawn, if your date is in OCONV(XXX,"D4/") format, do this:
VAR$ = YOUR.DATE
VAR$ = ICONV(VAR$,"D") ; * convert to internal format
MONTH.NAME = OCONV(VAR$,"DMA") ; * alphabetic month
MONTH.DAY = OCONV(VAR$,"DD") ; * numeric day of month
MONTH.YEAR = OCONV(VAR$,"DY") ; * numeric year of month
CRT /cur.date \:OCONV(MONTH.NAME,"MCT"):" ":MONTH.DAY:", ":MONTH.YEAR
To view this discussion on the web visit https://groups.google.com/d/msgid/mvdbms/CANKEuc4%3DJrE_wFP8dM_q_B0TPpkDqqWq_x1KqqOBu%3D6ZJ6YonQ%40mail.gmail.com.
Dawn Wolthuis
On Dec 15, 2021, at 4:05 AM, Martin Phillips <mphi...@rocketsoftware.com> wrote:
To view this discussion on the web visit https://groups.google.com/d/msgid/mvdbms/SA0PR07MB767633B2910366BCD97EFD14C8769%40SA0PR07MB7676.namprd07.prod.outlook.com.
philippe GRACIA
jj="0":oconv(d,"dd")
jj=jj[len(jj)-1,2]
mm=oconv(d,"dm")
if len(mm)=1 then mm="0":mm
mm=mm[len(mm-1),2]
mmmm=oconv(d,"dma")
jjjj=oconv(d,"dwa"):" ":jj
aaaa=oconv(d,"dy")
aa=aaaa[3,2]
if fmt="" then fmt="JJ/MM/AAAA" ; * french format
ret=swap(fmt,"AAAA",aaaa)
ret=swap(ret,"AA",aa)
ret=swap(ret,"MMMM",mmmm)
ret=swap(ret,"MM",mm)
ret=swap(ret,"jjjj",jjjj)
ret=swap(ret,"JJ",jj)
return
