Hi, Try OCONV(DATE(),'DDMY[,A,Z4]')
Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jonathan Leckie Sent: 22 March 2013 10:15 To: 'U2 Users List' Subject: Re: [U2] Date conversion.. 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 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
