Hi ,

I need to change the format of the date-time date field.
e.g.-2008/05/27 14:07:11:740 to 05/27/2008 HH:MM
The orginal field format is (HYYMDS) and i need to change it to MM/DD/YYYY HH:MM.

Please suggest.
Thanks.

Hi B_B,
Try this example.


DEFINE FILE EMPLOYEE
NEWSAL/D12.2M = CURR_SAL + (0.1 * CURR_SAL);
RAISETIME/HMDYYI = DT(20000101 09:00:00AM);
END

TABLE FILE EMPLOYEE
PRINT LAST_NAME FIRST_NAME NEWSAL RAISETIME
IF RAISETIME EQ '20000101 09:00AM'
END

Try HMDYYI