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:
The date-time field should show this data as follow:
Thank you for your helpThis message has been edited. Last edited by: FP Mod Chuck,
Windows, All Outputs
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);
TABLE FILE CAR
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
|Powered by Social Strata|