Forum Discussion
Default field in a table
In my database I a table with a field have a field called "Year" and at the moment this is set to a default for the current year i.e. 2019 and I have to change it each year. Can this field be update...
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.