Focal Point
[SOLVED] Back to dates
July 13, 2010, 10:37 PM
ray_In_Vancouver [SOLVED] Back to dates
trying to convert '04/04/10' to
2010-04-04 00:00:00.000
Thanks
This message has been edited. Last edited by: Kerry , July 19, 2010 03:48 PM
July 13, 2010, 10:51 PM
njsden Check the documentation for the HDTTM function to make your Date a Date-Time field.
Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2Test: Dev. Studio 8008 /Windows 7 (Local) Output: HTML, EXL2K.July 13, 2010, 10:54 PM
njsden You can then use HCNVRT to convert your Date-Time into an alphanumeric expression which you can then massage as needed to obtain the exact output you expect.
Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2Test: Dev. Studio 8008 /Windows 7 (Local) Output: HTML, EXL2K.July 14, 2010, 01:20 AM
Waz Are you tring to convert a Smart Date to Date Time? or is it Text ?
If its a Smart Date, then see what njsden posted.
If its text, then a but of dialog manager and the DT function will do.
Waz... Prod: WebFOCUS 7.6.10/8.1.04 Upgrade: WebFOCUS 8.2.07 OS: Linux Outputs: HTML, PDF, Excel, PPT In Focus since 1984 Pity the lost knowledge of an old programmer!
July 14, 2010, 06:43 AM
ray_In_Vancouver quote:
HDTTM
COMPUTE Eff_Date1/A6YMD=EDIT(SUBSTR(1000, LINE, 12, 19, 8, 'A8'),'99$99$99');
Gives me 04/04/10 IN Eff_Date1
COMPUTE TS/HYYMDS = HDTTM(Eff_Date1, 10, TS); errors
trying to get it to
2010-04-04 00:00:00.000
July 14, 2010, 07:22 AM
ray_In_Vancouver GOT IT SOLVED
thanks
COMPUTE Eff_Date0/A8 = SUBSTR(1000, LINE, 12, 19, 8, 'A8'); NOPRINT
COMPUTE Eff_Date/HYYMDS = HINPUT(8, Eff_Date0, 8,'HYYMDS');