Focal Point
[CLOSED]INCORRECT USE OF DATE-TIME FIELD OR CONSTANT

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/649108364

June 11, 2010, 02:23 AM
Yangyang
[CLOSED]INCORRECT USE OF DATE-TIME FIELD OR CONSTANT
...I want convert the date time to char, but faild...

below is test code:

DBDATETIME : 2009-06-02 00:00:00.000

  

TABLE FILE SQLOUT
PRINT
COMPUTE TEST1/HYYMDm = DBDATETIME;

-*COMPUTE TEST2/A100 =TEST1;



how can I write the TEST2 ? i want print the char date wiht html loyout.

Thanks,
James

This message has been edited. Last edited by: Yangyang,


WebFOCUS 7.6.8
WebFOCUS 7.6.10
BI
FLEX
.NET
June 11, 2010, 02:43 AM
Waz
Please check the H functions, ther is one for converting a datetime to text, it has been mentioned in the forum before.

You should get yourself a copy of the Functions manual it is free to download, use the documentation link above.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

June 11, 2010, 02:49 AM
Yangyang
thanks Waz,

I searched , but i didn't fount yet...

i try a lot of ways... but it's not work well..


this way can fix this issue:
  

COMPUTE TEST1/HYYMDm = date;NOPRINT
COMPUTE test2/A50 =HCNVRT(TEST1, '(HYYMDS)', 20, 'A20'); NOPRINT




Thanks,
James

This message has been edited. Last edited by: Yangyang,


WebFOCUS 7.6.8
WebFOCUS 7.6.10
BI
FLEX
.NET
June 11, 2010, 04:03 AM
Tony A
James,

Check out the HCNVRT function.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10