Hey guys. I have a requirement to display a date in a different format than it is stored in our table.

So I used the following command to get the format that I want in a PDF:
STRT_DTE/MDYYYY = HDATE(ARL_START_DATE, 'MDYYYY');

The problem is that the report is too wide to fit on 1 page, so I would like to spit out excel reports instead.

However when I run the same code but produce excel output, I dont get dates at all in that column, just large integers.

Whats the deal?

quote:

However when I run the same code but produce excel output, I dont get dates at all in that column, just large integers.

Are you doing excel or exl2k the second one keeps formatting.

Try using the alpha type of format for your dates - A8MDYY

T

Hi,
I ran the following without any problem:

DEFINE FILE CAR
TDY/DMYY='&DATEDMYY';
N/I3 WITH COUNTRY = LAST N + 1;
CDATE/DMYY WITH COUNTRY=TDY + N;
END
TABLE FILE CAR
PRINT CDATE
BY COUNTRY
ON TABLE PCHOLD FORMAT EXL2K
END