I always use : OCONV(DATE(),'DDMY,A,Z4')
In data that is going to a spreadsheet, it means Excel knows it is a date and stops Excel changing the format to American (we are based in the U.K.). -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sathya Sent: 22 March 2013 7:30 am To: [email protected] Subject: [U2] Date conversion.. Hi experts.. I have one problem in creatin a spreadsheet report with date format. One of the column in the spreadsheet is a date and it is displaying as numbers. Please help me in printing it as a date. BTW I'm using OCONV to write the value to the column. TIA, Sathya V. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users Blairs Windows Limited is a company registered in Scotland. Company No: SC393935. Registered office: 9 Baker Street, Greenock, PA15 4TU. V.A.T. registration No: 108729111 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
