Welcome :Guest
Congratulations!!!

MDX problem: Return the number of days in a given selection/range

I've had this problem for a couple of days and found some "solutions" online. However, none of them worked. The goal is to calculate Inventory Turnover, but the problem is I can't seem to return the current number of days in the selection. The solution I found was: Count(Descendants([Date].[Date Hierachy], [Date].[Date Hierachy].[Date])) Which returned this: http://www.jandd.be/images/q_return.jpg However, I just want it to return the number of days that are in the selection, so the number of days between (incl) 22/08 and 25/09. This is a screenshot of my datedim, if it helps: http://www.jandd.be/images/q_datedim.jpg I can imagine this could be real simple or some setting that I didn't find on the dimensions, but it would be really appreciated if I could find a solution like this...

How can I calculate the Number of days between two dates Monday to Friday

`    I am using following code for Robert's Posted Code (Url:http://forums.asp.net/t/1142378.aspx) But this is for only calculate weekends saturday and sunday can any one tell me how     I get Number of days between given two dates Monday to Friday.`

```            private const int MONDAY = 1;
private const int TUESDAY = 2;
private const int WEDNESDAY = 3;
private const int THURSDAY = 4;
private const int FRIDAY = 5;
private const int SATURDAY = 6;
private const int SUNDAY = 7;

/// <summary>
/// Observe that the method calculates by including the start day, but excludes the end day
/// </summary>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <returns></returns>
private void GetWeekendDaysBetween(DateTime startDate, DateTime endDate,out int saturdays,out int sundays)
{
saturdays = -1;
sundays = -1;
if (endDate < startDate)
return;
TimeSpan timeBetween = endDate.Subtract(startDate);
int weekendsBetween = timeBetween.Days / 7;
sundays = ```

Count the number of months since start date Options

I have a Measure.TransactionValue and also a Date.Month Dim and a
Subscriber Dim

I want to do a Count of months since first transaction date by
Subscriber

i..e
Subscriber | Month | Measure.TransactionValue |
Measure.MonthsSinceFirstTran
1 | 201002 | 0 | 0
1 | 201003 | 100 | 1
1 | 201004 | 200 | 2
1 | 201005 | 300 | 3
1 | 201006 | 0 | 4
1 | 201007 | 50 5

Make sense?

Any help would be greatly appreciated.

How to create a calculation in a list - Calculate the number of days between two dates

I have a calculated column in a list called Days Open. This column contains the number of days between today (Sysdate) and another column called the Effective Date. Therefore, if Sysdate is 11/16/2010 and the Effective Date is 10/14/2010, how do I calculate the number of days between the two dates?

I tried using this formula: =TEXT(Sysdate-[Effective Date],"h") and then I tried =INT(Sysdate-Effective Date) & TEXT(Sysdate-Effective Date, ":hh:mm")

Neither formula worked. I hope it is something real simple that I am missing here. Any help you can provide will be highly appreciated!

function to calculate number of business days in a month for a given date

hi ,

Is there any function to calculate number of business days in a month for a particular date.  my input would be just a single date

thanks,

Vishal

Convert English to Arabic number without changing any regional settings in .net

Well, most applications that I worked with was multilingual that supports English UI and Arabic UI.

And one of the major issue that we have faced is displaying Arabic numbers without the need of changing the regional settings of the PC.

So the code below will help you to display Arabic number without changing any regional settings.

dynamically adding sql server columns based on number of files in fileuploader

I want to create a new table to sql database at runtime.  The column names would be "Name", "Date", "Event".  I would also like to have one more column name "Image" but the problem is that since the amount of images will vary, I want the application to count the amount of files in the Multiple fileuploader and then add a image column to the table for the respected amount of files.

For example if i am uploading 3 files in the multiple fileuploader, the names should be "Name", "Date", "Event", "Image1", "image2", Image3"

I also would like that table name to be name dynamically from the textbox Name when the user enters the information.

I have the following code to make a new table, but I dont know how to name the fields at runtime like previously asked please help!!!

objConn.Open()

Embeb a variable number of videos

I need to provide some alternate content for my non-Flash users.

I have a directory of video files that is scanned using the DirectoryInfo() function, and I want to use the results to embed all files ending in ".mov" in QuickTime players on a web form.

How would you approach this? Right now I am using the count on the array of videos to determine how many times to repeat the embed code.  But this seems inelegant.

Is there a way to have a single QuickTime player.ascx control that gets duplicated according to the number of videos available for display?

Article commenting by line number

I'm wondering what's the best way to approach an online article system that allows users to comment by clicking on the line they are commenting about? Essentially the same way Adobe Acrobat works with comments where you can click anywhere and the text is saved for that location.

I'm assuming a mix of jQuery would be the crux of the interface. The system would need to save comments so that when another user logs in, they will also see the other comments but they canÃÂ´t edit them - only add their own.

Any suggestions would be great.

The number of members in the conceptual type ... does not match with the number of members on the ob

Hello,

I've added a scalar property to an entity and now ASP.NET Dynamic Data scaffolding throws this error:

The number of members in the conceptual type 'TrainingModel.Users' does not match with the number of members on the object side type 'TrainingModel.Users'. Make sure the number of members are the same.

This happens at the following line in global.asax:
`model.RegisterContext(typeof(TrainingModel.TrainingEntities), new ContextConfiguration() { ScaffoldAllTables = true });Please help!`
Thanks

huge number of data from database ... so how to minimize load time

Hi ...

I have used the above method to configure my crystal report ...

Its working fine , But i have huge number of data in database ....

So , it take long time to load the report ...

So , i have decided to show only the last 50 records inserted into the database , not all the 500 records to be loaded every time.

Plz help me with this issue  ...

Also , Plz explain me abt index legend in crystal report.

How to show 0 as first number in column

Hi guys. I have two little problem.

I have database with one table and it has 4 rows.

1. I want to show a zero in front of all number. Actually i added but it doesn't show.

2. If i don't put any value in column is it possible to have minus for example instead of 0?

http://dox.bg/files/dw?a=632de0c7c6

http://dox.bg/files/dw?a=c98fc6df8c

http://dox.bg/files/dw?a=83fb8efbba

I post it like that because i can't see how to post pics directly.

P.S. The columns with numbers have checked "allow nulls".

I draw in paint so it's not so good but i think it's understandable.

'Meter number is not registered ' error FedEx ship web service move to production

Hi,

I want to integrate FedEx ship web service in my website. It works fine for local but for production it gives error. I changed test credentials by production credentials. also changed test url "https://gatewaybeta.fedex.com:443/webservices" by production url "https://gateway.fedex.com:443/webservices" But I am getting error that meter number is not registered. Please advice.

Function to return number

I am trying to create a function that  return the number part within / / from a url if exist:

For exmple:

I prefer if possible to use regular expression. Any help would be really appreciated.

IIS - sharepoint/default website port number confusion

Hi,

I have MOSS 2007 installed with IIS V7.

My default web site port is 80. When I created a new web application for my main sharepoint portal I also set it to 80. So obviously now the default web site port shows as stopped in IIS and it won't start.

What are the best practices. Should I change the port number for my portal to something else? I mean is it even a good idea to have sharepoint on port 80? If so, how do I go about changing the port number for my portal site?

any help appreciated.

Rounding a number based upon it's midpoint

I need to round down, or round up a floaitng point number to it's closest integer value.
So for example 3.49999 is closer to 3 so it would round down to the integer 3.
3.5002 is closer to 4 so this would round up to the integer 4.

I do not need to be concerned negative numbers. Can someone show me how to do this?

Here are more examples to make clear what I am talking about

RequiredFieldValidator minimum 6 number

Hi,This my code:<asp:RequiredFieldValidator ID="RequiredFieldValidator2" ValidationExpression="^[a-zA-Z0-9]{6,}\$" runat="server" ControlToValidate="CreditCardNumber"  ErrorMessage="Stevilka kreditne kartice, ki ste jo vnesli, ni veljavna!"                 ValidationGroup="ErrormessageValidationGroup">!!!!!!</asp:RequiredFieldValidator>ValidationExpression not works! The condition must be at least 6 numbers before it is implemented.thanks
 Categories:
 ASP.Net Windows Application .NET Framework C# VB.Net ADO.Net Sql Server SharePoint Silverlight Others All