I have a list with the fields "Effective" and "Expires". Both fields are Date and Time data types. I want to show the list items where the current date/time is greater than Effective and less than Expires.
I believe my code below looks only at the Expires Date and NOT at both date and time. I'm not an XSL developer so any help would be GREATLY appreciated!! (tried to format code but not much luck)
Thanks.

1 Answer
1

Your SelectCommand only refers to the Expires column so you would need to add an AND clause and your other column in there if you want to filter by both.

Do you need to do all this by code? If not then add your web part to the page using the browser interface and set up the view and filters that way. You can then save your StyleSheet and link it to the web part in the Miscellaneous section using the XSL Link box.