Solved

Migrating dates in different formats

Posted on 2011-03-07
3
286 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
3 Comments
 
LVL 3

Accepted Solution

by:
JAMcDo earned 350 total points
Comment Utility
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 150 total points
Comment Utility
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
Comment Utility
Giving you both points, more to JAMcDo since he answered first.  2nd opinion always helps though.  Thanks experts!
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
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…

763 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now