Forum Discussion
Default field in a table
J0hn60rt0nmentions Instead of hard-coding a value, use the relevant Date function, which is Year(). Since you want to use the following year, not the current year, you'd use Year(Date())+1
Hi George, Many thanks for the help and it works, That's great ....... Super ......
John
J0hn60rt0nmentions Congratulations on solving the problem. Continued success with your project.
George Hepworth Hi George, many thanks for the message. I have tried it it I get a error message say "Expression entered has a function containing the wrong number of arguments" I have tried it in most of the relevant formats Number, Date/Time/and Short text. Any ideas please. What I thought would happen would be, as the database went over in to the next year the year will be auto updated which is what happens in the Date() function.
