Dates are difficult to handle in a database environment. In real life we can live with a uncertain date as July 2018 or just the year 1968 or even "This picture was taken in the sixties". But in a database we can only handle exact dates with all figures as date-month-year. To overcome this the following rule is implemented:

If we only know the year 1989, we can enter only the year (1989), and the date is saved i the database as 01-01-1989 and the time as 00:07:00.

If we know the year and the month, we can enter the month and year (1989-10 or  10-1989), and the date is saved as 01-10-1989 and the time as 00:09:00.

So this is a way to use the time factor as a way to control what is showed on the form, for an easy reading.

The last uncertainty "The sixties" can only be entered as 1965 f.ex. (And will be saved as 01-01-1965 00:07:00)

Created with the Personal Edition of HelpNDoc: Write eBooks for the Kindle