Update: Since I can manually delete the time via ent. mgr, effectively zeroing out the time, I had the idea that I could put a trigger on that table to do that. I'm not a sql guru by any stretch, but I got it working great last night.

However, when I tested it, the role (student in this case) still couldn't view the pages. I could update it via DNN and it would work. But not via the trigger.

I heard back from Susanne at Catalook who reported that it worked w/DNN 4.4.1 and Catalook 5.2, which isn't out just yet. She did attempt to email me the pa, but Exchange Defender destroyed the zips and she was gone for the weekend by the time I realized it.

So now I'm wondering what, if anything, does DNN do differently upon insert, or update, to that table. I looked at the sproc for adding user roles and it didn't reveal anything out of the ordinary. And in looking at the dependencies, it doesn't appear that I would need to perform an action on another table.

It's a real bummer as I need to have these roles assigned to customers who purchase a certain product.

Any ideas?

Here's waht I ended up doing. I went back to a table trigger, but instead of:
CREATE TRIGGER [ZeroUserRolesTime] ON [dbo].[UserRoles]
FOR INSERT, UPDATE, DELETE
AS
Update UserRoles
Set UserRoles.EffectiveDate = Cast (Floor (Cast(effectivedate as float)) as datetime)
    from userroles where effectivedate is not null

I did a trigger with:
Update UserRoles
Set EffectiveDate = Null
where RoleID=3

and it works fine. Hopefully, either the next version of Catalook or DNN will resolve it.