?
Solved

Migrating dates in different formats

Posted on 2011-03-07
3
Medium Priority
?
330 Views
Last Modified: 2013-11-05
I have an access database that has a date field formated "mm/dd/yyy" but I'm going to be importing it into a field that is formatted "yyyy/mm/dd".

Will I need to do anything special on the import to ensure the data doesn't get messed up when I import it?
0
Comment
Question by:gcgcit
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 3

Accepted Solution

by:
JAMcDo earned 1400 total points
ID: 35057326
I think that the date format of the target will take care of the change of date format.

J.
0
 
LVL 19

Assisted Solution

by:MINDSUPERB
MINDSUPERB earned 600 total points
ID: 35057494
I go with  JAMcDo. The Date format doesn't affect the value of the date so I don't see any issue when you do the import/export.

Sincerely,
Ed

0
 

Author Closing Comment

by:gcgcit
ID: 35058012
Giving you both points, more to JAMcDo since he answered first.  2nd opinion always helps though.  Thanks experts!
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question