or taking it a step further… have expiration_datetime, and if it’s all day, set the time part to 23:59:59 or similar… Then there would be only one place to look to see whether the task has expired.
mindok
evadne
mindok
Depending on your time grain (in this case 1s), it would be the last moment of the day, so is a valid solution provided it isn’t important whether you knew a time was selected or not.
0
evadne
No
Expiration in this case is a moment in time and 23:59:59 is still a valid moment in time
Albeit most of the time harmless, it is not ideal to use such a value as a magic value that implies additional meaning
0