View Complete Post
This seems to be a bug when the crawler search the user profiles in MOSS 2007. When crawled, user profiles with a SPS-HireDate in the months of January, April, August and December will be detected, but a full-text (SQL) search returns those profiles
without the HireDate field.
User profiles with HireDates in other months work correctly, returning the HireDate in the search. And changing the month of a problematic user profile also fixes the problem.
This problem is also reflected in the fact that while we have 499 user profiles using the SPS-HireDate property, the managed property page from the search section only has 350 items with the HireDate property.
We're running MOSS 2007 32bit with SP2 with an English language base and the Spanish language pack. I'd considered date format problems, but I can't imagine how some months would work, while others wouldn't.
I have a custom list with information about our customers and when we need to renew there equipment. When we add entries to the list we have field called Renewal date where we select the date the equipment needs renewing.
I would like to create a workflow so I can select the entry click on workflows and set the entry to email me 1 month before the renewal is due.
I am using SBS 2008 and WSS 3.0
Thanks in advance
I have no clue why my query is acting weird
If i try to run it for 1/1/2010 9/30/2010 the query takes around 1min 26 sec and return around a million rows
and If i run for 8/1/2010 to 8/31/2010 it takes forever to it...
basically i am getting data from 5 tables and putting it in a temp table and then updating that temp table 2-3 times with some information and then displaying it.
I am stumped as to why it works fast for a longer date range and runs the snail for a small period of time..
I am in the verge of pulling my hair and going crazy..
any help will be appreciated.
I am using two columns in one table such as StartDate,Enddate.
In asp.net Form two text boxes there. One is StartDate other one EndDate..
When user Click Submit button the Two dates is compare above DataFiled's...
-------- Data Base Values ----------------
user send Start Date ' 27/09/2010' and EndDate '30/09/2010'
Now the Query Check Dates Between Userdates avialable in Database....
What I ll do?????
(Note : Opertion only allow the Dates Not Exists in Database Dates)
It is required to retrieve the records where ONLY Start Month, Year AND End Month, Year are passed. Trying below SQL to get these with no success.
registrationdate BETWEEN(MONTH((registrationdate) = 01) AND (Year(registrationdate)= 2009)) AND ((Month(registrationdate) =03) AND (Year(registrationdate)=2010))
Help is appreciated.
query.Append("SELECT Name, Sex, Marital_Status, Dob, Anniversary, Mobile, Email FROM Client WHERE ");
if (startDate > new DateTime() && endDate > new DateTime())
query.Append("(DATEADD(YEAR,DATEDIFF(YEAR, DOB,'" + startDate + "'),DOB) BETWEEN '" + startDate + "'AND'" + endDate + "' OR DATEADD(YEAR,DATEDIFF(YEAR, ANNIVERSARY,'" + startDate + "'),ANNIVERSARY) BETWEEN '" + startDate + "'AND'" + endDate + "') AND ");
if (!string.IsNullOrEmpty(maritalStatus) && !string.Equals("All", maritalStatus))
query.Append(" Marital_Status = '" + maritalStatus + "'");
string resultQuery = query.ToString();
if (resultQuery.Trim().EndsWith("AND", StringComparison.OrdinalIgnoreCase))
int lastIndex = resultQuery.LastIndexOf("AND");
resultQuery = resultQuery.Remove(lastIndex, 3);
int lastIndex = resultQuery.LastIndexOf("WHER
How can i check if a type (of class Type) is numeric, text or date? Is there a simple method for this already?
Currently I'm checking it like this:
if(type == typeof(Int16) || type == typeof(UInt16) || type == typeof(Int32) ... and so on) return "numeric";
I was wondering if there was a asp JScript function that will tell me what week of the month it today is.
I mean F Oct 8 2010 = 2 week of the month and S Oct 10 2010 = 3rd week of the month
I am a very new bie to SSAS/MDX. I am developing a report on existing ssas cube. My report shud be sme thing like this
Todays date M2D
A,B,C are measures in my cube . So I want to create caluclated members for sum(A),sum(B),Sum(C) between startday of month and today.So that I can drag caluclated members into my report. I have trsansaction date as dimension. Please help
me in regarding . Looks simple but not getting enough hands on doing this.
Thanks in advance. Awaiting for the reply.
I have a table having the columns of (ID StartDate EndDate)
how can i retrieve the ID's of all the rows when a date passed is in between the startdate and enddate.
Thanks in Advance