Bear in mind EventsGetByRange is used all over the place, sop anything you do will affect thing like Search, SiteMap, Month, List, Day view, etc. So would recommend it for a module which is very limited in scope, preferably list view display only.

---

DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback

---

Requirements/Bugs - Please submit them on Codeplex

Have a look at the EventsSave sproc on how to do IF statements in sprocs. If it was me I wouldn't change the queries I would override the input values near the start of the sproc. So:

IF @ModuleIDs = N'618'
 Select @BeginDate = startdate'

Not sure if you can put two nested statements under the IF. If not just do the same but with @EndDate as well. The thing I'm not sure about is the structure of the hard coded date. I think it has a # in it somewhere, so you may have to do some google searching.

If you always want it to be for current year, you could always construct the date by using the current year. Datepart is the relevant SQL command to get the year component Datepart(year, GetUTCDate()) - http://msdn.microsoft.com/en-us/libra...

Cheers
Roger

---

DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback

---

Requirements/Bugs - Please submit them on Codeplex

You don't need to declare moduleid, @moduleids is already declared as an input parameter. Note the 's' on the end and the fact it is a string. This is because if your module has sub-calendars these will be included in the string comma separated.

Yes on aage where the moduleid is 618, moduleids will be the string value 618.

---

DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback

---

Requirements/Bugs - Please submit them on Codeplex