| 1 | | Notes on dates |
| | 1 | = Formatting Dates to be read by MetPetDB bulk uploader = |
| | 2 | |
| | 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 |
| | 5 | * Then, convert your date in whatever format to MetPetDB format by entering in the new column: |
| | 6 | * '''=TEXT(C2,"yyyy-mm-dd")''' ''for dates with specific days'' |
| | 7 | * '''=TEXT(C2,"yyyy-mm")''' ''for dates with just month and year information'' |
| | 8 | * '''=TEXT(C2,"yyyy")''' ''for dates with just the year'' |
| | 9 | * Apply these formulas to all of your dates |
| | 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 | * Remove any unreadable columns containing formulas or other information that MetPetDB does not include. |
| | 12 | [[BR]] |
| | 13 | [[BR]] |
| | 14 | |
| | 15 | [wiki:SampleObject Back to sample details].[[BR]] |
| | 16 | |
| | 17 | [wiki:ChemicalAnalysisObject Back to chemical analysis details]. |
| | 18 | |
