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

How to print date as dd-mmm-yyyy on reports?

0 views
Skip to first unread message

David Ho

unread,
Feb 23, 2003, 3:33:49 AM2/23/03
to
Is there a way to be able to do this? Thanks

Anders Altberg

unread,
Feb 23, 2003, 5:23:36 AM2/23/03
to

"David Ho" <davi...@pacific.net.sg> wrote in message
news:00a301c2db16$499e74c0$a001...@phx.gbl...

> Is there a way to be able to do this? Thanks

David,
Before running the report
SET DATE DMY
SET CENTURY ON
SET MARK TO '-'

mmm id that the three-letter month name?
SET DATE LONG will show dates the way you've set it up in the Control
Panel's Regional date settings.
Programmatically
transform(day(date)) +' '+left(cmonth(date),3)+' '+transform(year(date))

-Anders


0 new messages