Parameter Date Print



Parameter Date Print

By Warren Hinchliffe
Link Market Services

Start with a question on Focal Point: Is there a way to Print Parameter date if user is inputting Parameter date in the following format: 2011/01/01.

I used

	-SET &ENTDT = &ENTDT
	DEFINE FILE BLABLA
	DATEENT/A8YYMD = &ENTDT
	END
	TABLE FILE BLABLA
	PRINT DATEENT
	END

It gives a formatting error.

Solution:

There are three options available.

1, Use Smart Dates

-SET &ENTDT = '2011/01/01' ;
DEFINE FILE CAR
DATEENT/YYMD WITH COUNTRY = '&ENTDT' ;
END
TABLE FILE CAR
PRINT DATEENT
END

2, Format A10

-SET &ENTDT = '2011/01/01' ;
DEFINE FILE CAR
DATEENT/A10 WITH COUNTRY = '&ENTDT' ;
END
TABLE FILE CAR
PRINT DATEENT
END

3, Remove the slashes


-SET &ENTDT = '2011/01/01' ;
DEFINE FILE CAR
DATEENT/A8YYMD WITH COUNTRY = STRIP(10,'&ENTDT','/','A8') ;
END
TABLE FILE CAR
PRINT DATEENT
END