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  |  

Affordable ASP.NET Hosting Service
  Ads  
Iron Speed Designer is a software development tool for building database, reporting, and forms applications for .NET without hand-coding.
 


  Sponsors  

Meet Our Sponsors

SteadyRain
DataSprings - Great Ideas. Always Flowing.
R2integrated - formerly bi4ce
Jango Studios - Skins, Modules and Hosting for DotNetNuke
eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
SmarterTools
 


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.
 


ExactTarget Email Marketing Software and Solutions
ExactTarget delivers on-demand email software solutions for permission-based email marketing. ExactTarget offers solutions that meet the needs of all industry verticals and all size organizations, including SMB, corporate divisions, not-for-profits, large retail/direct marketers, agencies and enterprises.
ExactTarget.com 		Sunset Hill Solutions - Consulting and Development
We offer general DNN consulting services - including custom module development and commercial module integration/setup.
www.sunsethill.ca 		MaximumASP
MaximumASP provides a wide array of web hosting plans to fit any hosting need. We also provide software and services needed to keep it running optimally.
MaximumASP.com

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