Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

PortalWebHosting
  Ads  
Aspose - The .NET & Java component publisher
 


  Sponsors  

Meet Our Sponsors

Portal Webhosting - Hosting For Developers
Red-Gate Software
MaximumASP
SourceGear - Tools for Developers
.: CounterSoft :.
telerik
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Reports Module ...  Globaly recognized functions
Previous Previous
 
Next Next
New Post 2/16/2007 4:09 PM
User is offline Tony Thompson
102 posts
9th Ranked


Globaly recognized functions 
I read in another post that DNN recognizes things like @ModuleID, @UserID, @TabID as current module, user and tab. I was wondering if there are ways to filter the reports on current month, say if i wanted to print out a report of this months events. I'd imagine it would go something similiar to "SELECT Description FROM Events WHERE EventUserID = @UserID AND Month(EventDate) = Month(Date)".  In this example we modified the events to accept a user id to only show events for the currently logged in user, and the Month(EventDate) would return the month of the event, and Month(Date) would return the month of the current date.
 
New Post 2/28/2007 12:23 PM
User is offline PK
2 posts
10th Ranked


Re: Globaly recognized functions 

Your query is almost right: this month would be MONTH(GETDATE()).

You'll also need to test on year to make sure they match:

WHERE MONTH([eventdate]) = MONTH(GetDate()) and YEAR([eventdate]) = YEAR(GetDate())

 
 
 Page 1 of 1
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Reports Module ...  Globaly recognized functions
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
 


Perpetual Motion Interactive Systems Inc.
A solutions company specializing in Microsoft enterprise technologies.
www.perpetualmotion.ca 		Icthus Technologies
Building Faith on the Internet
www.icthustech.com 		Efficion Consulting
A premier DotNetNuke consulting firm providing complete DNN services including: custom module development, skinning and design, installation and integration services.
www.efficionconsulting.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP