A userid/password created using sp_iqaddlogin and set to expire in one day is now defined as valid all day tomorrow and invalid on the following day. In other words, a login created today and set to expire in n days will not be usable once the date changes to the (n+1)th day.