Build a Date 1

[spongie1]

I have linked the my database to an excel spreadsheet. Changing the layout of the spreadsheet is not an option.

The spreadsheet lists year, month, and day separately.

Is there a function to build a date from these components?

I want to make a query that reconstructs these components into a "useable" date field.

I am sure this has been answered before.

Do I calculate the correct integer value for the particular day, then build from there (probably)? If so... How?

Or do I build some sort of string comprised of these values... (I am guessing no).

 

[SkipVought]

Hi,

In VB

MyDate = DateSerial(year, month, day)

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[spongie1]

You are a gentleman and a scholar.

Many thanks.

Have a star