Design and CSS styles
Version 3.x > Design and CSS styles > Order By DateNow View modes: 
User avatar
Member
Member
contacto-innovamedios - 11/10/2008 2:39:22 PM
   
Order By DateNow
Hi, i need in the News and Events only show the news and events of actual Month, how can to make that?

thx

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 11/11/2008 3:31:49 AM
   
RE:Order By DateNow
Hi,

in the repeater that is displaying the news and events, please configure the WHERE condition to be like this:

(MONTH(NewsReleaseDate) = MONTH(GETDATE())) AND (YEAR(NewsReleaseDate) = YEAR(GETDATE()))

You may need to change the "NewsReleaseDate" field name to the name of your date field.

Best Regards,
Juraj Ondrus