This table has a A26 field that I need to convert to Date-Time field.

I will use the Date-Time field to group transactions processed within a certain time window during a giving day.

Lets say I want to group all the transactions that were processed on 2017/03/07 between:
- Group A: 8:00:00 to 08:59:59
- Group B: 9:00:00 to 09:59:59
and so on.

The A26, provides the following information:
2017-03-07-02.26.30.187908
2017-03-07-13.34.40.779502
2017-03-07-05.39.56.017517

The date-time field should show this data as follow:
2017-03-07 02:26:30
2017-03-07 13:34:40
2017-03-07 05:39:56

Thank you for your help

This message has been edited. Last edited by: FP Mod Chuck,

Should be able to accomplish this by using the HIPNUT and EDIT functions.

HINPUT
EDIT

Hi,

try below code,

SET DEFCENT=19, YRTHRESH=20
SET DTSTANDARD = ON
DEFINE FILE CAR
D_DATE/HYYMDS = DT(2017-03-07-02.26.30.187908);
END
TABLE FILE CAR
PRINT D_DATE
BY COUNTRY
END

Thanks