Hi

I have the date format 2007/12/31 00:00:00.000 from the datasource


My desire output format is 12/31/07

How to achive it ?
Thanks in advance

ENGINE SQLORA SET DATETIME OFF or some derivative. You may also need to reformat the date.

Hi Ricky

I am using SQL Swrver 2005

Change the usage format to MDY .

Hi Brian

How to set usage format ? In where we have to set ?

The dateformat you have is something like

HYYMD I suppose

You can see that in the master file.

To change this can be done in several ways.

suppose you do this in the define

DEFINE FILE whatever
NEWDATE/YYMD=HDATE(ORIGDATE, 'YYMD');
END

Hi Frank

I got this error

(FOC002) A WORD IS NOT RECOGNIZED: Dt/YYMD


when i use the code

SQL SQLMSS
SELECT * FROM ;


TABLE FILE SQLOUT

PRINT
*
ON TABLE HOLD
END

TABLE FILE HOLD
PRINT
EndDate AS ''
Dt/YYMD = HDATE(EndDate, 'YYMD');
Full_Name AS ''
Account
Branch_Name AS ''
BY EndDate
END



Please help me to solve this issue

change this in

SQL SQLMSS
SELECT * FROM ;

TABLE FILE SQLOUT

PRINT 
* 
ON TABLE HOLD
END

DEFINE FILE HOLD
Dt/YYMD=HDATE(EndDate, 'YYMD');
END

TABLE FILE HOLD
PRINT
Dt AS ''
Full_Name AS ''
Account
Branch_Name AS ''
BY Dt NOPRINT
END

Thanks Frank

I got the 2007/07/31 format only even i change the format YYMD or other formats .... Can i change any intial Parameter for this


Thanks in Advance

Well you should read the manual.
You can do so many things with this software, but without the manual and maybe some training you won't get all the possibilities working for you.
It will take some time, we work with Focus for almost 20 year....

Hi

in the following example my field DATECREATED IS A DATETIME FIELD and I changed the display of it by creating the field test and I could see the date displayed as wanted it.

test/HDMY = INVENTORYANDPRODUCTVIEW.INVENTORYANDPRODUCTVIEW.DATECREATED;