Sorted....

You know when you just keep looking after bugs you get blind on smaller details, iv switched the Startdate and Enddate around in the DATADIFF function.

If anyone else wana make a report of subscribers and exspire date you can use this code as inspiration:

SELECT dnn_Roles.RoleName as Abonnement, dnn_Users.FirstName as Fornavn, dnn_Users.LastName as Efternavn, dnn_Users.Email, dnn_UserRoles.ExpiryDate as Udløbsdato      
 FROM dnn_Users
  INNER JOIN dnn_UserRoles on dnn_UserRoles.UserId = dnn_Users.UserId
  INNER JOIN dnn_Roles on dnn_UserRoles.RoleId = dnn_Roles.RoleId
 WHERE  dnn_Roles.PortalId = 1
  AND    (EffectiveDate <= getdate() or EffectiveDate is null)
  AND    (DATEDIFF(day, GETDATE(), dnn_UserRoles.ExpiryDate) <= 20) 
  AND (dnn_Roles.RoleName like '%Subscripers%')
 ORDER BY dnn_Roles.RoleName