Importing/Exporting dates and time

[bonitashar]

I have run into a few problems trying to import and export dates and time. Let me try to explain what the problem is and what I need and see if there are any solutions.

1- When exporting time to Eudora it shows up as military time but I would like to have an am/pm format. Can this be changed?

The next few problems come from excel worksheets that contains statements we receive every quarter.

2- I have an excel worksheet that one of the fields contains three types of data:

-it is blank

-Date formated as December 3, 2002

-the Date plus a string of unnecessary words

The problem is I need to extract just the date and have it formated as mm/dd/yyyy.

3- In the same excel worksheet there is a field that contains the year and a number representing the quarter. ex: 20011 (year 2001 quarter 1). I need to have this changed to the last date of the quarter ex: March 31, 2001.

I hope this makes sense and that someone can help.

Thank you.