Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
quote:
The HDATE function converts the date portion of a date-time value to the date format YYMD. You can then convert the result to other date formats".
Syntax: How to Convert the Date Portion of a Date-Time Value to a Date Format
HDATE(datetime, output)
where:
datetime - Date-time - Is the date-time value to be converted, the name of a date-time field that contains the value, or an expression that returns the value.
output - Date - Is the format in single quotation marks or the field that contains the result.
TABLE FILE VIDEOTR2
PRINT CUSTID TRANSDATE AS 'DATE-TIME' AND COMPUTE
TRANSDATE_DATE/YYMD = HDATE(TRANSDATE, 'YYMD');
WHERE DATE EQ 2000;
END