By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,640 Members | 2,279 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,640 IT Pros & Developers. It's quick & easy.

where am I going wrong

P: n/a
My competitors table has Memberid, lastname, first name, and I have three
other fields (all number) year month and another for day. I decided to
combine the year, month and day into one date field.

so I created a new field with a date/time format
then I created an update query and put date as my field name
and then I tried in the update section
=dateserial:([year]&{month}&[day})

and I could not get my date field to update.

I am new at this and wondered what syntax should I have used.

or is this the right way to do this.I did an internet search but couldn't
find anything useful

thanks


Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Mon, 03 May 2004 02:58:56 GMT, "Anne" <am******@ns.sympatico.ca>
wrote:

Why are you using { and }?
I don't think that's supported syntax.
Try [ and ] instead.

-Tom.
My competitors table has Memberid, lastname, first name, and I have three
other fields (all number) year month and another for day. I decided to
combine the year, month and day into one date field.

so I created a new field with a date/time format
then I created an update query and put date as my field name
and then I tried in the update section
=dateserial:([year]&{month}&[day})

and I could not get my date field to update.

I am new at this and wondered what syntax should I have used.

or is this the right way to do this.I did an internet search but couldn't
find anything useful

thanks



Nov 12 '05 #2

P: n/a
Joy
try this:
[year]&[month]&[day]

omit the brackets.

"Anne" <am******@ns.sympatico.ca> wrote in message news:<Qz*********************@ursa-nb00s0.nbnet.nb.ca>...
My competitors table has Memberid, lastname, first name, and I have three
other fields (all number) year month and another for day. I decided to
combine the year, month and day into one date field.

so I created a new field with a date/time format
then I created an update query and put date as my field name
and then I tried in the update section
=dateserial:([year]&{month}&[day})

and I could not get my date field to update.

I am new at this and wondered what syntax should I have used.

or is this the right way to do this.I did an internet search but couldn't
find anything useful

thanks

Nov 12 '05 #3

P: n/a
I removed the brackets and used
=dateserial:[year]&[month]&[day]
but is still doesn't work so any other suggestions.
The three fields I am combining are general number and I am combining into a
date/time field so could this cause the problem. Also not all the records
have data in year, month, day.

Any help is appreciated. I made the mistake of creating the table this way
and would have been so much better off with a date/time field in order to
manipulate the dates in the database. I want to update about 1000 records so
it would be so much easier to do so by an update.

"Anne" <am******@ns.sympatico.ca> wrote in message
news:Qz*********************@ursa-nb00s0.nbnet.nb.ca...
My competitors table has Memberid, lastname, first name, and I have three
other fields (all number) year month and another for day. I decided to
combine the year, month and day into one date field.

so I created a new field with a date/time format
then I created an update query and put date as my field name
and then I tried in the update section
=dateserial:([year]&{month}&[day})

and I could not get my date field to update.

I am new at this and wondered what syntax should I have used.

or is this the right way to do this.I did an internet search but couldn't
find anything useful

thanks


Nov 12 '05 #4

P: n/a
Anne wrote:
My competitors table has Memberid, lastname, first name, and I have three
other fields (all number) year month and another for day. I decided to
combine the year, month and day into one date field.

so I created a new field with a date/time format
then I created an update query and put date as my field name
and then I tried in the update section
=dateserial:([year]&{month}&[day})

and I could not get my date field to update.

I am new at this and wondered what syntax should I have used.

or is this the right way to do this.I did an internet search but couldn't
find anything useful

thanks

MyDate = dateserial(2004,5,3)
returns 5/3/2004. You need to use commas instead of ampersands. IOW,
DateSerial uses 3 arguments

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.