[SOLVED] Converting A26 field to Date-Time field (HYYMDs)
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 helpThis message has been edited. Last edited by: FP Mod Chuck,
WebFocus 7703 Windows, All Outputs
March 24, 2017, 12:05 PM
Barron
Should be able to accomplish this by using the HIPNUT and EDIT functions.
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