Re: edit dd/mm/yyyy

[Allan Geetter <geetter@UHAVAX.HARTFORD.EDU>]

I had the same problem.  This is what I had to do:

 Begin-Select
GURALOG_OBJECT         ()  ON-BREAK LEVEL=1 PRINT=NEVER AFTER=OBJECT_BREAK
GURALOG_USERID         ()  ON-BREAK LEVEL=2 PRINT=NEVER AFTER=USER_BREAK
GURALOG_REASON
to_char(GURALOG_ACTIVITY_DATE,'mm/dd/yy HH:MI pm') &date
GZBANUSER_NAME

 Then, I just issued the print command as

   Print &Date                      (,52,17)

 You set the format with the to_char command in the select

Arthur Coniglio wrote:

> 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.
>
>   ------------------------------------------------------------------------
>
>    Part 1.2       Type: application/ms-tnef
>               Encoding: base64


begin:          vcard
fn:             Allan  Geetter
n:              Geetter;Allan
org:            University of Hartford
adr;dom:        200 Bloomfield Ave.;;Information Technology Services - CC125;West Hartford;Connecticut;06117-1599;
email;internet: geetter@uhavax.hartford.edu
title:          Data Security Administrator
tel;work:       (860) 768-4889
tel;fax:        (860) 768-4907
x-mozilla-cpt:  ;0
x-mozilla-html: TRUE
version:        2.1
end:            vcard