![]() |
||||||||||||
Go ![]() | New ![]() | Search ![]() | Notify ![]() | Tools ![]() | Reply ![]() | ![]() |
Silver Member |
It seems that the above format is not supported with new date formats. If I change it to MD/MtrDY then I get the proper output. But, drop off the Y and I either get the 2 digit month. Ie: DEFINE FILE CAR RUN_DATE/YYMD WITH COUNTRY =&YYMD; RDATE/YYMtD=RUN_DATE; DISPDATE/MtrDY = RDATE; MD/MtrDY = RDATE; END TABLE FILE CAR PRINT COUNTRY RUN_DATE MD END This works, remove the "Y" on MD and there is an error. The question is how do I get the date without the year? (I need this removed since I sort across Year) Steve | ||
|
Silver Member |
Alas, this is an inventory report showing week ending inventories compared between years, so there is an across sort on year, and I have to leave year out of the displayed date. I guess I have to cobble it together some other way. | |||
|
<Pietro De Santis> |
DEFINE FILE CAR TODAY/YYMD WITH BODYTYPE= '&DATEYYMD'; END TABLE FILE CAR TODAY TODAY/MTDYY TODAY/MTDY TODAY/DMY TODAY/M TODAY/MT TODAY/MTR COMPUTE M/M = TODAY; NOPRINT COMPUTE MX/I2 = M; NOPRINT COMPUTE D/D = TODAY; NOPRINT COMPUTE DX/I2 = D; NOPRINT COMPUTE MTR/A9 = DECODE MX ( 01 January , 02 February, 03 March , 04 April 05 May , 06 June , 07 July , 08 August 09 September, 10 October , 11 November, 12 December ELSE ''); NOPRINT COMPUTE MTRD/A12 = MTR || (' ' | EDIT(D)); TODAY/MTRDYY WHERE RECORDLIMIT EQ 1 END | ||
|
Silver Member |
Thanks, I think that will do it. Steve | |||
|
Expert |
DEFINE NEWTIME/HYYMDIA=DT(&YYMD 12:00AM); NICEDAY/HMtD = NEWTIME; will give you Aug 24 for NICEDAY I can't get it to give you August 24 Mtr doesn't work. | |||
|
<Pietro De Santis> |
I like it! NICEDAY/HMtD = NEWTIME; NICEDAY2/HMTD = NEWTIME; Capital MT gives the full month in title case! | ||
|
Powered by Social Strata |
![]() | Please Wait. Your request is being processed... |
|