Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Date Conversion

695 views
Skip to first unread message

PaulP

unread,
Jul 6, 1999, 3:00:00 AM7/6/99
to
Hi, Everybody

Does anyone know what the date conversion is to produce yyyymmdd format?

Cheers

Gary Kempster

unread,
Jul 6, 1999, 3:00:00 AM7/6/99
to

PaulP wrote:

> Does anyone know what the date conversion is to produce yyyymmdd format?

I'm not aware of any single conversion that will do this although I'm sure
someone will correct me if i'm wrong :o). However, you could build a string
as follows:

NEWDATE = OCONV(DATE(),"DY"):OCONV(DATE(),"DM") "R%2":OCONV(DATE(),"DD")
"R%2"

Cheers,

Gary.

Mark Brown

unread,
Jul 6, 1999, 3:00:00 AM7/6/99
to PaulP
How about:

Basic:
oconv(date(),'dy'):oconv(date(),'dm')'r%2':oconv(date(),'dd')'r%2'

Correlative:
f;d(dy);c10000;*;d(dm);c100;*;+;d(dd);+

Mark

=======================

PaulP wrote:
>
> Hi, Everybody


>
> Does anyone know what the date conversion is to produce yyyymmdd format?
>

> Cheers

--
Sincerely,


--
Mark Brown
Manager, Continuing Engineering
Pick Systems, Inc. USA


Dew knot trussed yore spell chequer two fined awl mistakes!

Leebert

unread,
Jul 6, 1999, 3:00:00 AM7/6/99
to
You could also try OCONV(DATE(),'D4YMD') then all you would need to do is
put it in a TRIM statement and remove the 2 spaces.

PaulP <ppark...@idealnet.co.uk> wrote in message
news:7lsken$2d7$1...@news1.cableinet.co.uk...

gerry simpson

unread,
Jul 7, 1999, 3:00:00 AM7/7/99
to
the 'all in one solution' that produces YYYYMMDD exactly :

OCONV(DATE(),"DYMD[4,2,2]":@VM:"MCN")

Keith Pearson

unread,
Jul 9, 1999, 3:00:00 AM7/9/99
to
In article <7ltugv$b15$1...@nntp3.atl.mindspring.net>, "Leebert" <lwpr...@mindspring.com> says:
>
>You could also try OCONV(DATE(),'D4YMD') then all you would need to do is
>put it in a TRIM statement and remove the 2 spaces.
>
>PaulP <ppark...@idealnet.co.uk> wrote in message
>news:7lsken$2d7$1...@news1.cableinet.co.uk...
>> Hi, Everybody
>>
>> Does anyone know what the date conversion is to produce yyyymmdd format?
>>
>> Cheers


Need to know the platform first. Differs between UD UV D3 etc....

Keith Pearson
>>
>>
>
>

Ray Wurlod

unread,
Jul 13, 1999, 3:00:00 AM7/13/99
to
Try this (in UniVerse anyway)

Oconv(Date(), "D-YMD[4,2,2]":@VM:"MCN")

The "D-YMD[4,2,2]" produces "yyyy-mm-dd" format, and the "MCN" filters out
any non-numeric characters.

PaulP wrote in message <7lsken$2d7$1...@news1.cableinet.co.uk>...

ty...@webtime.com.au

unread,
Jul 13, 1999, 3:00:00 AM7/13/99
to
On realityX oconv(date(),"DS") will produce the output you require.
This does not function on jBase.

Regards

Paul Homer

Kumar V

unread,
Aug 7, 2023, 4:47:00 PM8/7/23
to
On Wednesday, July 7, 1999 at 3:00:00 AM UTC-4, gerry simpson wrote:
> the 'all in one solution' that produces YYYYMMDD exactly :
>
> OCONV(DATE(),"DYMD[4,2,2]":@VM:"MCN")
> "PaulP" <ppark...@idealnet.co.uk> wrote:
> >Hi, Everybody
> >
> >Does anyone know what the date conversion is to produce yyyymmdd format?
> >
> >Cheers
> >
> >
It worked in 2023. Thank you so much.
0 new messages