Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Converting A26 field to Date-Time field (HYYMDs)
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Converting A26 field to Date-Time field (HYYMDs)
 Login/Join
 
Member
posted
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,


WebFocus 7703
Windows, All Outputs
 
Posts: 11 | Registered: November 09, 2012Reply With QuoteReport This Post
Member
posted Hide Post
Should be able to accomplish this by using the HIPNUT and EDIT functions.

HINPUT
EDIT


App Studio 8105; Win 7 x64; HTML, Excel
 
Posts: 8 | Registered: December 14, 2016Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
 
Posts: 182 | Location: INDIA | Registered: July 11, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Converting A26 field to Date-Time field (HYYMDs)

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.