Changes between Version 2 and Version 3 of Dates

Show
Ignore:
Timestamp:
06/15/09 16:00:02 (4 years ago)
Author:
halleb3@…
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Dates

    v2 v3  
    22 
    33A date must be in a specific format in order to be recognized by MetPetDB. MM-DD-YYYY, YYYY-MM-DD or any shortened version (i.e. YYYY, or, YYYY-MM) is acceptable.  Microsoft excel has a number of built in date formats, yet dates are stored as serial dates and are not reable by the MetPetDB uploader.  To solve this problem, MetPetDB recommends: 
    4  * First, create a blank column adjacent to your date column in the spreadsheet 
     4 * First, create a blank column adjacent to your date column in the spreadsheet. 
    55 * Then, convert your date in whatever format to MetPetDB format by entering in the new column: 
    66  * '''=TEXT(C2,"yyyy-mm-dd")''' ''for dates with specific days'' 
    77  * '''=TEXT(C2,"yyyy-mm")''' ''for dates with just month and year information'' 
    88  * '''=TEXT(C2,"yyyy")''' ''for dates with just the year'' 
    9  * Apply these formulas to all of your dates 
     9 * Apply these formulas to all of your dates. 
    1010 * Create a column of dates in text format by copying the entire column and "paste special" with just values to the date column. 
    1111 * Remove any unreadable columns containing formulas or other information that MetPetDB does not include.