- 06/15/09 16:00:02 (4 years ago)
v2 v3 2 2 3 3 A 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 5 5 * Then, convert your date in whatever format to MetPetDB format by entering in the new column: 6 6 * '''=TEXT(C2,"yyyy-mm-dd")''' ''for dates with specific days'' 7 7 * '''=TEXT(C2,"yyyy-mm")''' ''for dates with just month and year information'' 8 8 * '''=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 10 10 * Create a column of dates in text format by copying the entire column and "paste special" with just values to the date column. 11 11 * Remove any unreadable columns containing formulas or other information that MetPetDB does not include.