Re: edit dd/mm/yyyy

["Stokman, Gilbert" <Stokman.Gilbert@KPMG.NL>]

If I want to get a date field from the database 2 look like DD/MM/YYYY I
do this:

begin-select
to_char(datefield,'DD/MM/YYYY')
        move &to_char(datefield,'DD/MM/YYYY') to $begin_dt
from ps_table
end-select

The $begin_dt var. is now containing a DD/MM/YYYY format date!

Gilbert Stokman
Cap Gemini Netherlands

> ----------
> From:         Arthur Coniglio[SMTP:Arthur.CONIGLIO@EDDEPT.WA.EDU.AU]
> Reply To:     SQR-USERS@USA.NET
> Sent:         woensdag 28 januari 1998 1:49
> To:   Multiple recipients of list SQR-USERS
> Subject:      edit dd/mm/yyyy
> Importance:   High
>
> --- Virus checked / Op virussen gecontroleerd ---
> G'day all.
>
> Can someone please tell me if you have ever used the   EDIT DD/MM/YYYY
> function
> with the print command.   I have a date in database format held in a
> variable and attempting to
> print it the format of my choice.  All i get printed to the report is
> DD/MM/YYYY and not the
> actual date ??
>
> Example.      print  $Begin-Dt     (,+5)     edit dd/mm/yyyy
>
> Has anyone had any luck with this.
> Any ideas appreciated.
>
> Cheers
> Arthur.
>

================================================================================
De informatie verzonden met dit E-mail bericht is uitsluitend
bestemd voor de geadresseerde.
Gebruik van deze informatie door anderen dan de geadresseerde is verboden.
Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze
informatie aan derden is niet toegestaan.
KPMG staat niet in voor de juiste en volledige overbrenging van de inhoud
van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
================================================================================
The information contained in this communication is confidential
and may be legally privileged.
It is intended solely for the use of the individual or entity to whom
it is addressed and others authorised to receive it.
If you are not the intended recipient you are hereby notified that any
disclosure, copying, distribution or taking any action in reliance
of the contents of this information is strictly prohibited and may be
unlawful. KPMG is neither liable for the proper and complete
transmission of the information contained in this communication nor for
any delay in its receipt.
================================================================================