This might be the wrong place to ask but I have no other ideas.
I know SQL a lot but I just can't get this thing with mySQL(MariaDB) to work,
probably since my knowledge about the syntax ain't at 100%.
My problem is to get a functional MariaDB-query with date fields.
I also have a isdiabled-field but that is no problem.
The fields are a fromDate and a toDate and are both nullable.
The problem is how I handle if these date-fields is 'null', not 'null' or some of it.
Think of it like this;
Both these dates can be 'null' and if so that the row should be gathered.
If there ain't a start date then only the end date would be stopping the query
and vice versa, all towards current date.
(NOT TIME!!! just the date)
If this was in MSSQL I would fix it, no problem, but I do not know all the syntax of MariaDB
to get this to work. I've googled a lot but probably not using the correct words for that either.
Please help an old man :P
