I am trying to get an sql query that will do the following:

Give me a list of users that would include

FirstName, LastName, DisplayName, Email and a "custom" field I put in that is a date that their license from the state expires.

From looking at the database here is what I can determine.

FirstName, LastName, DisplayName, Email is from the Users table
The "expiration date" is the "PropertyValue" for "PropertyDefinitionID" '78" from the UserProfile table

Only thing is I am clueless on how to write the query.

Can anyone help?

Thanks in advance,

Mike

Ok I'm blind. I don't see a link above.

I googled dnnForge and didn't come up with anything useful.

Mike