TMG-L Archives

Archiver > TMG > 2004-10 > 1097979767


From: Afina Broekman <>
Subject: RE: [TMG] Dates in list of events report
Date: Sat, 16 Oct 2004 22:23:15 -0400
References: <5.2.1.1.0.20041016134142.00bb7480@incoming.verizon.net>
In-Reply-To: <200410162318.i9GNIkOX023474@ms-smtp-04.nyroc.rr.com>


>To get your List of Events report to sort by date, Click on the Options
>button on the Report Definition screen. Then choose the Output Column tab.
>For the first item to be output, choose Date. Then put a 1 in the box to
>the left of it. This should then sort your report by date when you print

Thanks Sue, it should. However if I export to Excel, it sorts as text: so I
get 02 Nov 1749, 04 Nov 1770, 15 Nov 1744, etc. That's why I wanted the
output to go YYYY.MM.DD, and I can't seem to find a way to get that in the
report :-(

Afina

>it.
>
>- Sue -
>
>-----Original Message-----
>From: Afina Broekman [mailto:]
>Sent: Saturday, October 16, 2004 12:51 PM
>To:
>Subject: [TMG] Dates in list of events report
>
>I want to generate a list of events, and sort by the event date. GTMOOTMG
>says on pg 269 that reports have a date option. However for the list of
>-- reports, that option does not seem to exist. I would like the output
>to read :yyyy.mm.dd Is this indeed impossible?
>
>Afina
>
>Afina Broekman
>Fair Lawn, NJ, USA
> or
>http://afinab.tripod.com/
>Gast, de Haan: Netherlands; Ten Bruggencate: anywhere
>Broekman/Brockman, Koch: Germany, Netherlands
>Richstein/Reichstein, Brodie, Levison, Streicher: Ukraine, New York;
>Edelman: New York
>Seidler: Germany, New Jersey
>
>
>==== TMG Mailing List ====
>Visit the TMG Tips web site <http://www.tmgtips.com>; for items of interest
>to TMG users and links to other TMG related sites.
>
>
>
>
>==== TMG Mailing List ====
>To un-subscribe from TMG-L (in MAIL mode), send a message to
><> [to <> in Digest
>mode] with just the word "unsubscribe" (no quotes)in the text and turn off
>your signature.

Afina Broekman
Fair Lawn, NJ, USA
or
http://afinab.tripod.com/
Gast, de Haan: Netherlands; Ten Bruggencate: anywhere
Broekman/Brockman, Koch: Germany, Netherlands
Richstein/Reichstein, Brodie, Levison, Streicher: Ukraine, New York;
Edelman: New York
Seidler: Germany, New Jersey

This thread: