Vaccine Dates not recorded

Ok, must be some windows local date setting on your server that is causing an issue, or, perhaps you're running a very old version of firebird.

older firebird.

Mine likely is: Firebird-1.5.3.4870-0-Win32.exe

Pretty old .. been using 2.nn for over a year now.

I guess it was not casting the date into a timestamp and so gave a null value.

Any upgrade suggestions ? Uninstall ... Install ?

I'd like to use the version you are using.

http://www.firebirdsql.org/index.php?op=devel&sub=engine&id=fb212_release

Should this worry me ?

No, it should not be a problem.

the benefit of using 2.1 is nbackup which provides differential backups - though this was broken in 2.1 and was supposed to be fixed in 2.1.1

which version are you using ?

How about this one ?

http://www.firebirdsql.org/index.php?op=devel&sub=engine&id=fb204_release

2.0.4 ?

I'd go for a newer version.

alter table vaccinations alter column vdate type timestamp

to reverse ?

No, no need as I am not actually asking the user to enter hours:mins:secs:tz data so leave it as date field.

In fact the next server will do this for them ie swap over to date field.

If anyone has <null> in the vdate of the immunizations,

use IBO console command

update vaccinations set vdate = 'NOW' where vdate is null

to chage the null to today.