Date() returning wrong date (30/12/99)

[Nelmo]

I have created a form with an 'Add New' button that adds a new record, gives focus to the date field and fills in today's date, i.e. Forms!frmConcrete![Date] = Date(). However the date displayed is always 30/12/99.

Any thoughts as to why?

Thanks in advance

Neil

 

[Mile-O]

Date is a reserved word in Access. You should not name your controls: Date.

Solve it here

 

[Rich]

Check your regional settings and system date, also don't have a field called Date, it's a reserved word in Access

 

[Nelmo]

Sorted

Thanks both of you

I always call my date fields Record_Date, Order_Date, etc. I was rushing this time.

Never too late to teach an old dog new tricks!!

Nelmo

 

[Mile-O]

Re: Sorted

Thanks both of you

I always call my date fields Record_Date, Order_Date, etc. I was rushing this time.

Never too late to teach an old dog new tricks!!

Nelmo

Even better with: RecordDate and OrderDate. Try to avoid symbols in your names too.

When you start coding, etc, you find that you will have more syntax problems as fields with underscores or spaces have to be surrounded by square brackets in code and SQL. One word names (one word in the sense that it can be multiple words but just contain spaces) don't.