creating a date from numbers in a field

's Computer Specifications

Hi,

i have several fields which i need to combine to create a date field.

any suggestions as to how to do this are most welcome.

many thanks,

S

's Computer Specifications

You need atleast 3 (Day, Month and Year) fields to create a date. Do you have
them ? If so, concatenate them into a string 'dateString' and call the method
Date( dateString ).

"simon" wrote:

> Hi,
>
> i have several fields which i need to combine to create a date field.
>
> any suggestions as to how to do this are most welcome.
>
> many thanks,
>
> S

's Computer Specifications

Hi simon.

"simon" wrote:
> i have several fields which i need to combine to create a date field.
> any suggestions as to how to do this are most welcome.

Try to use the DateSerial function. It creates a date from three separate
values: year, month an day.

--
Regards,
Wolfgang

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: Creating a Month field from a date field	Bill Mosca, MS Access MVP	Microsoft Access	0	12th Dec 2006 04:27 PM
Re: Creating a Month field from a date field	fredg	Microsoft Access	0	12th Dec 2006 04:22 PM
Creating simple batch numbers from selected date....	Blippy	Microsoft VB .NET	2	22nd Aug 2005 10:37 AM
Creating a custom date field	=?Utf-8?B?VmlrYXMgQXJ5YQ==?=	Microsoft Access VBA Modules	2	29th Jul 2005 06:00 PM
Creating date field	=?Utf-8?B?S2VpdGggTWVpZXIsIE1DU0E=?=	Microsoft Access Forms	5	15th Jun 2005 04:08 AM