Posted to microsoft.public.excel.programming

D.S.[_3_]

external usenet poster

Posts: 60

AS400 Date value conversion to Excel

I have an excel query that return dates from an AS400 system, and the date
'as is', is almost useless for my presentation. For instance, today's date
12/3/03, would be returned as 1031203.

Any suggestion to convert this to the MMDDYY format above? It would be
great if I could add some type of conditional statement to the SQL code in
the query, but could also use an Excel worksheet formula in the adjacent
column to convert the value.

D.S.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Stop date conversion in Excel when pasting	Stephanie	Excel Discussion (Misc queries)	4	February 20th 11 07:58 PM
Losing date values upon conversion from EXCEL to CSV	Robert Judge	Excel Discussion (Misc queries)	0	July 28th 08 09:29 PM
Excel date conversion-UK to US	lainy	Excel Worksheet Functions	1	February 14th 08 12:49 PM
Turning off Date Conversion in Excel	Ken Hutchinson	Excel Discussion (Misc queries)	4	July 31st 06 09:09 AM
as400	ayeFayze	Excel Discussion (Misc queries)	1	April 20th 05 09:12 AM

All times are GMT +1. The time now is 12:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us