How do I set a value that automatically increases by 1 every day?
Hi, i'm building a database for a scientific experiment. One of my fields is "Day number" and I want this to automatically set a number which is the number of days since the start of the experiment. For example, if I start the experiment 28/01/2014, that value would be 1 and on the 29th, that value would automatically change to 2, and 3 on the 30th etc..
There will be a new record every day.