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] Date format
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Date format
 Login/Join
 
Gold member
posted
Hi,
I have date format "20190123000000000" in the system and I used
 COMPUTE BATCH_DATE1/MDYY = HDATE(BATCH_DATE, 'MDYY');  AS 'BATCH_DATE' 
the out put I`m getting '1232019', but my requirement is the data format should be "01/23/2019",

This issue is only with CSV format, HTML and EXL07 are doing good


Appreciated any help to change the format.

Thanks,
krishna

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


WebFocus-8/Windows/HTML, PDF, EXCEL
 
Posts: 88 | Registered: September 20, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Have a look at HCNVRT().


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1641 | Location: Enschede, Netherlands | Registered: August 12, 2010Reply With QuoteReport This Post
Gold member
posted Hide Post
Hi Wep5622,
Thank you for your reply, it is working fine but I`m still getting the time, here is my code
and my output
 COMPUTE  PAYMENT_DATE1/A20 = HCNVRT(PAYMENT_DATE, '(HYYMDS)', 20, 'A20');AS 'PAYMENT_DATE1' 

output: 10/28/2018 12:00:00 AM
I need only date part (10/28/2018) only, how can I control this?

Thanks,
Krishna


WebFocus-8/Windows/HTML, PDF, EXCEL
 
Posts: 88 | Registered: September 20, 2010Reply With QuoteReport This Post
Gold member
posted Hide Post
I Fixed it using EDIT function to mask the time,

Thanks,
Krishna


WebFocus-8/Windows/HTML, PDF, EXCEL
 
Posts: 88 | Registered: September 20, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Date format

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