Database Manager Users - Valid From and To Dates One Day Out

A place to discuss any bugs or issues you have encountered with the software
Post Reply
User avatar
robinwilson16
Site Admin
Posts: 184
Joined: Sun Oct 16, 2016 6:46 pm
Forename: Robin
Surname: Wilson
College Name: FEA
Position: MIS Consultant
LinkedIn Profile: https://www.linkedin.com/in/robinwilson16

Database Manager Users - Valid From and To Dates One Day Out

Post by robinwilson16 » Tue Nov 08, 2016 8:46 pm

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. :think:

The same problem occurs with the valid from date.

With this example the account would not be valid on 02/12/2015:
Database Manager Users.png
Database Manager Users.png (105.67 KiB) Viewed 108 times

senev777
Posts: 4
Joined: Wed Oct 19, 2016 9:36 am
Forename: Chaminda
Surname: Seneviratne
College Name: North Herfordshire College
Position: Consultant

Re: Database Manager Users - Valid From and To Dates One Day Out

Post by senev777 » Fri Nov 18, 2016 9:28 am

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

User avatar
robinwilson16
Site Admin
Posts: 184
Joined: Sun Oct 16, 2016 6:46 pm
Forename: Robin
Surname: Wilson
College Name: FEA
Position: MIS Consultant
LinkedIn Profile: https://www.linkedin.com/in/robinwilson16

Re: Database Manager Users - Valid From and To Dates One Day Out

Post by robinwilson16 » Sun Nov 20, 2016 2:20 pm

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:

Code: Select all

CAST ( '2015-12-02 00:00:000' AS DATE )
Hopefully it will be an easy bug for them to fix.

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests