how can i filter my crm reports by date?
155823
in your query to the database, include criteria on the date field to filter the data retrieved.. or simply include an 'ORDER BY 'statement in the SQL statement to sort your data then you can simple manipulate the data
1144655
You can use either google's calender service or yahoo's calender service.You can look into them using your yahoo or google desktop or widget engine.
883282
It would depend on your table structures, but it should look something like this:\n\nSelect <student info>\nFrom <table name>\nWhere <table name>.<birthdate field name> = <date of feb>
9806
This is bacaouse the report is pointing to a database Path which was hardcoded at the design time.\n\neg. While development the database path was C:&#92;Data&#92;Vbdata&#92;Myproject&#92;CRM&#92;data.mdb\n\nbut you might not have the database at same path. so ask the developer to rectify the mistake
887481
Create a query with all of the fields you want in the report\n\nIn the criteria area under the department field put this\n\nLike [Enter Department Name] and between #[Enter Start Date]# and #[Enter End Date]#\n\nThen create a report based on the query and it will give you a repot that only includes the department you asked for
721930
echo date("Y-m-d",strtotime("+5 days"));\n\necho date("Y-m-d",strtotime("+21 days"));
619962
I use several where I am. Some are filed by date and some by client. Even still, some are filed by document and filing date.
552871
For a good listing of the latest CRM softwares in the market today, check out http://www.wareprise.com/content/customer-relationship-software.html\n\nThe new Microsoft CRM 3.0 is also quite good since I've seen a demo of it. Pretty impressive.
750784
OpenOffice has a forum where you can put your query... they shall be able to help you out.... quickly.
362803
You should add more details ... your field names, table name, database type (e.g. Access, Informix) etc.\n\nThe code below assumes your database is MS SQL Server\n\nSELECT AmtPaid, Firm_Number AS [Firm#],Payment_Date As DatePaid,Payment_Number As [Payment#]\nFROM Payments\nWHERE (DatePaid >= '2005-06-01' AND  DatePaid <= '2005-06-10') AND Firm_Number = 1115
186354
Easy - \n\nDim someDate As DateTime = DateTime.Parse(yourString)
484857
hahaha first answer made me laugh.\n\nThat is true, no body uses foxpro, though, you migh do this:\n\nselect * from table where date>initialdate and date<enddate. This really works.
1006970
look at the newsgroup  news:alt.comp.software.financial.quickbooks\n\n(also under google groups)
5801
Without having any idea what software or operating system you are using, I can't say for sure.  Most e-mail readers/services offer this function though.  Try searching for "spam filter", "junk email", or "rule" in your software's help file or web service's FAQ.
8550
I recommend Ninotech Date Edit 4.0 (freeware)\nhttp://home.worldonline.dk/ninotech/freeutil.htm
81121
You will find that if you place a text box control on the report and make its control source [Begin Date:] spelt exactly like it is in the query then the value that you enter when the query executes will also be written to the report. Its that easy
879651
To my knowledge MS Exchange does not keep an access log to shared calendars. In short, no, I don't think so.