Jump to content

Importing/Exporting dates and time


This topic is 7831 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

This topic is 7831 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.