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] Custom Time Format
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Custom Time Format
 Login/Join
 
Gold member
posted
Hi,

How can i display time field/column in custom format in excel instead of alpha/general?
example time: 10:00 AM

Thanks You
Sandhya

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


WEBFOCUS 8202/Windows
PDF/HTML/XML
 
Posts: 52 | Registered: December 06, 2011Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Sandhya

I did this with the report caster schedule file as that was the only one I had with a timestamp to test against. Hopefully you can translate it to your data.


DEFINE FILE BOTSCHED
HOUR_I/I2=HPART(BOTSCHED.BOTSCHED.LASTEXTIME, 'HOUR', HOUR_I);
HOUR/I2=DECODE HOUR_I(00 '12' 01 '01' 02 '02' 03 '03' 04 '04' 05 '05' 06 '06' 07 '07' 08 '08' 09 '09' 10 '10' 11 '11' 12 '12' 13 '01' 14 '02' 15 '03' 16 '04' 17 '05' 18 '06' 19 '07' 20 '08' 21 '09' 22 '10' 23 '11');
MINUTE_I/I2=HPART(BOTSCHED.BOTSCHED.LASTEXTIME, 'MINUTE', MINUTE_I);
AM_PM/A3=IF HOUR_I LE 11 THEN ' AM' ELSE ' PM';
TIME_OF_DAY/A10=EDIT(HOUR) | ':' | EDIT(MINUTE_I) | AM_PM;
END
TABLE FILE BOTSCHED
BY BOTSCHED.BOTSCHED.JOBDESC
BY BOTSCHED.BOTSCHED.LASTEXTIME
BY BOTSCHED.BOTSCHED.TIME_OF_DAY
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,
$
ENDSTYLE
END

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


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1905 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Gold member
posted Hide Post
Thank you Chuck


WEBFOCUS 8202/Windows
PDF/HTML/XML
 
Posts: 52 | Registered: December 06, 2011Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Custom Time Format

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