I'm trying to work out how many 1st of Septembers have occurred between two dates.
i.e.
2009-05-1 and 2010-08-02 = 1
2009-05-1 and 2010-09-02 = 2
I know that we can do a dateDiff to determine the number of days between two dates, I'm just having trouble getting some logic together.
I am wanting to write this in linq SELECT *FROM Store_InformationWHERE Date BETWEEN '12/03/2007' AND '01/04/2008'Can anyone give me an example?
View 1 RepliesI have this query:
[Code]....
I want to select dates that also fallin the range. Heres the scenario: I have an event from 01/20/2010 TO 01/25/2010. So right now it would only return a date of 01/20/2010. How could I return 01/20/2010, 01/21/2010 , 01/22/2010, 01/23/2010, 01/24/2010, 01/25/2010? Mind you only a start and end date are in the database.
how to right an SQL Query which will retreive Records of Tasks whose Deadline lies between two given dates.. The deadline is of type datetime.
View 5 RepliesWhere do I validate my date values prior to passing them as insert programs ?
I am trying to pass some Null dates.
In my property ?
[Code]....
[Code]....
[Code]....
a user will choose a period of time (from this date to this date) with a calendar ,, and then i want to get from DB all Invoices that were created within this period ??
each Invoice has a Date saved in Database..
This is the sql select statement i am using:
SelectCommand="SELECT [invoiceid] FROM [invoices] WHERE (([location] = @location) AND ([name] = @name)) AND date BETWEEN '"+ (fromdate.SelectedDate.ToShortDateString()) +"' AND '" + (todate.SelectedDate.ToShortDateString()) + "'">
i am getting this error message:
System.Data.SqlClient.SqlException: Conversion failed when converting date and/or time from character string.
how can we retrive records from sql-server between two dates. Dates are specied using DateTime datatype of C#. Also the stored date in sql is of Datetime type.
View 5 RepliesI want to be able to display the entries in this table based on the date and time of recorded in the entry.
So as an example:
Entry A only appears on Mondays at time X.
Entry B appears on Tuesdays at time X and Sundays at time X.
Entry C appears every day of the week at time X.
Entry D appears every day of the week but twice on each day at time X and y respectively.
I want to calculate the number of HOLIDAYS between two given dates. For example, to count the number of 'Fridays' and 'Saturdays' and any other holiday (can get from another table) in between two given dates.
For example,
Start Date: 16/07/2010
End Date: 22/07/2010
Holiday: 19/07/2010
OUTPUT: 3 Holidays (Since there are only two Fridays and Saturdays and one Holiday)
do also note that it must include count if the starting day or ending day is a holiday.
I have a web form that displays the results from a table. How can I compare the table between dates and display the differences of the table?
e.g. today 790 items, and two days ago there were 745 items and this is what is the difference;
xxx
yyy
ggg
hhh
aaa
etc.
i have DateFrom and DateTo columns in tblLOgs.if they both are same then select only DateFrom else both selects.my procedure is ....do modification in them
[Code]....
I want to create an application where I need to enter date to the ms access database.
I am a bit confused regarding how to make the user to enter date. The options avaliable are:
a. Shall I use a textBox?
b. Shall I go for 3 drop down lists?
or something else.
Some more questions:
1. what date format shall i use? (dd-mm-yyyy, dd-mmm-yyyy, etc, etc or anything else)
2. What datatype shall i use to store the date in the database?
3. What SQL query shall i use to retrieve the data between 2 dates?
let me know if there are multiple options available regarding this application.
I want to make this application as easy as possible for the user.
How would I determine the amount of time in weeks between two dates and compare that value to another value in Linq, for example:
Where the amount of time in weeks between (startdate and enddate) = value x
How to display dynamic header for datalist control(Dates are dynamic).Also i want header in each row.I want something like this.Words in bold are headers.Header also in each
row.8/1/2010,8/8/2010,8/15/2010,8/22/2010 are dynamic dates whic change every month based on user selecting date from datecontrol.
HeadCount 8/1/2010 8/8/2010 8/15/2010 8/22/2010
Forecaster HC 447 446 441 432
Agents Scheduled 447 446 441 432
I have a query that gives me the average number of days between 2 dates in the database. It gives an error saying line does not reconize the subtract method. What is the best way to do this, i prefere not to have to get the whole table as a list and loop though.
Using em As EE.EclipseEntities = New EE.EclipseEntities
Return em.OrderLines.Where(Function(w) w.Received_Factory_On.HasValue) _
.Average(Function(a) CDate(a.Received_Factory_On).Subtract(CDate(a.Sent_Factory_On)).Days)
End Using
when i run my application it is the error i get...This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1)
Please give me solution of this problem when i start defaut website then this error comes .I searched on net and found that make usre 80 port not in use.in cmd i gave netstat -b command and found no port 80 being used. So what to do with this.
View 8 RepliesRepeaterItemEventArgs e)
at System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource)
at System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e)
at _Default.up1_Load()
[code]...
is it happening in the Repeater1_ItemDataBound sub routine, or in the Timer1_Tick sub routine? Is the last thing that happened before the error occured at the top or bottom of the trace?
If i have three textboxes in my vb.net webform.
Textbox1.text="Sumit"
Textbox2.text="4-Dec-2010"
Textbox3.text="1-Jan-2011"
I want if dates selected are in between textbox2 dates and textbox3 dates then textbox1.text="sumit" else textbox1.text="No dates"
I need some pointers to start on this.We are building a time off application where three instances of a calendar control will be displayed ( prev - current and next month) now users can click on various dates accross all three instances and then a count of number of days should be diaplyed in the parent textbox.
To begin with this, i started with adding the dates clicked by the user in Calendar2_SelectionChanged method into a list<> so that i can get the all dates user clicked and then add it to calander's selected dates collection. But this throws an e" object reference not set" error.
Is there anyother way to get all the dates that user click onthe calendar( note the dates doesn't get highlighed so seleteddates doesnt work)does anyone has a good example for this.
I write code for save my Image file in one folderThe code as follow :SavePath = Server.MapPath("~/images/masterpageimage/");MasterFile.Save(SavePath + fname);This code perfectly run in my local machin but when I upload this codeto my server it give me error asxception Details: System.Runtime.InteropServices.ExternalException: A generic error occurred in GDI+.
View 1 RepliesI'm having a spot of bother deploying my database to my host using the Publishing Wizard. I'm using the .sql file generated along with RunSQL.aspx as discussed in this blog by Scott Guthrie.
The issue I am having is that the permission is set to dbo but this seems to be causing an issue with the hosted database as in I get the following error when I run RunSQL.aspx.
An error occured: System.Data.SqlClient.SqlException: Cannot find the user 'dbo', because it does not exist or you do not have permission. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ASP.runsql_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in d:~hosting details removed for security~RunSQL.aspx:line 88
Is there any way to make the Publishing Wizard set the owner to a particular username, i.e the username I use to access the hosted database.
i want to use a ajax calender extender in which when user clixcks on button caleder show only dates of current month not previous dates.i dont want to disable dates. i should not apper on current month calender. means it should start from 1 and end to 30 or 31
View 3 Repliesam working on web application in Viasual studio 2008 using ASP.NET with vb.
when i try to debug the web i got this error
Unhandeled Exception has occured in your application.
once a user select an item from dropdownlist > Dates from DB are shown on calendar in pink color.
The problem now is when i want to select new dates the selected dates(in pink) become deselected .. I want them to stay selected so i can know which dates are already used .
[Code]....