Dates

H

hogan

I have a situation where I need to calculate the age of a product when it was
purchased. I have a linked excel spreadsheet that includes the year of the
product as well as the date it was purchased. The year field is text and the
date purchased is in mm/dd/yyyy format. Except for changing the field
formats, is there a way to extract just the yyyy from the date purchased
field to do the calculations?
 
P

pietlinden

I have a situation where I need to calculate the age of a product when it was
purchased. I have a linked excel spreadsheet that includes the year of the
product as well as the date it was purchased. The year field is text and the
date purchased is in mm/dd/yyyy format. Except for changing the field
formats, is there a way to extract just the yyyy from the date purchased
field to do the calculations?
Click to expand...

use DatePart
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
printing report with date 2
Publisher is filling blank lines with data 2
Split a date 2
Date Formats 4
Properties - Format, Input Mask, Validation Rule 5
Forcing a date entry format of dd/mm/yyyy 1
Special Date Input Settings 2

Top