Unofficial UNIT-e Forum

We have noticed that the logic for allowing people to log in is not quite right as when someone leaves the organisation, if we put the correct valid to date in then the system won't allow them to log in on their last day before they leave.

If someone leaves on 08/11/2016 then the valid to date should be that date as the account should be "valid" on that date. However it stops working at the end of 07/11/2016.

The same problem occurs with the valid from date.

With this example the account would not be valid on 02/12/2015:

I think this is because Unite stores the date as 2015-12-02 00:00:000, which is basically end of 2015-12-01.

Thanks Chaminda

I see, that would make sense so in order to fix it they just need to cast the DATETIME value to a DATE to fix it probably so only the time part would be compared: Hopefully it will be an easy bug for them to fix.