3 Resources for

enddate

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

datetime literal update: I would like to know, if there is a way to update only the year portion of the datetime literal? Each row is to represent the months of the calendar year. ex: SET StartDate = '2007-1-1', EndDate = '2007-1-31'WHERE Period = 1StartDate(datetime,NULL)EndDate(datetime,NULL)I am wanting to change the year without having...; Tags: curtis_roseman@..., EndDate, datetime; Discussion threads 2007-09-13
Filters for all dates: Hey,I am using Between and AND to filter the dates in report what I have specified in two testboxes in relevant form. Its working on that but if I leave the textboxes blank. How will I get all the dates. Its showing error. May be Null value.Can anybody help me...; Tags: jdk@...; Discussion threads 2007-04-11
Grouping dates into days: I am trying to group a date Range result set of say one month into days between 22:00:00 and 21:59:59. I's this possible with SQL or do I have to do it in my .NET application?try this:SELECT * FROM yourTbl WHERE [date] BETWEEN 'startdate' AND 'enddate'That will return a result...; Tags: Databases, endDate, SELECT; Q&A 2005-09-20

Additional Resources

SharePoint 2007 - Calendar View using imported .xls with Outlook 2003 data: This isn't highly technical, as it's SharePoint development but I still need help. If you can help, please do!I have found the joys of the fact that Sharepoint can only talk one way, being TO Outlook, not talking to SharePoint FROM Outlook. I want to take a calendar from Outlook...; Tags: Groupware, Microsoft Office, Microsoft Outlook 2003, luv2flutterby78@..., Microsoft SharePoint, Microsoft Outlook, StartDate, Calendar View; Discussion threads 2007-06-27
Exporting to XML from Submit form: I am trying to Export information from a flash mx 2004 Submit form into an XML document.I do not want to overwrite the XML document but append to it.The XML file feeds a calendar I have created in flash so when the XML file is updated the Flash file is...; Tags: programming, wiseone@..., XML, XML file; Discussion threads 2005-08-17

Access 2000 Date Validation: Ok, so this is my problem.First, I am building a database in Access and using a form built in Access to add records. I am trying to do a form level validation with two date fields, a start and an end date. I don't want to force the validation at...; Tags: Databases, DATEDIFF, end date, start date, Microsoft Access; Q&A 2005-06-13
Using SQL Server JOINs for easy range lookups: Range JoinsI've also found range joins very useful on date fields.select *from customersinner join promotions on customers.dateadded between promotions.startdate and promotions.enddatefor example.I've used a few joins with > relation; Tags: gsquared; Discussion threads 2006-11-14
Report By Date range, Grouped into days: I am creating a Stored Procedure to query between a given date range as follows:SELECT Ksnr as 'Cust No', Artnr as 'Intier No', count(*) as QuantityFROM JITWork_ArchivWHERE (NOT (Sequenznr LIKE '0%')) AND (Letzte_Prioritaet =...; Tags: Dummy, DateTime; Discussion threads 2005-09-13
Javascript dropdown change: I'm sure this is probably very easy, but...I have a list of different charts that can be viewed by the user. Each chart is listed in a select list (there's about 30 charts, the select shows 10 at a time).Below the main select is a dropdown select.Each chart has...; Tags: chart, document.chartbook.strtdate.option, bt582@..., programming, new date, JavaScript, I=0; Q&A 2006-05-04
MS Access Query, Date and Time Trouble: Does anyone know how I can create a query that will let the user input a start date and an end date, and then show the results between specific, pre-determined times?For example: I want the user to be able to enter 8/8/07, when asked for the start date. Then...; Tags: Microsoft Access, JBowles@..., Microsoft Corp.; Discussion threads 2007-08-15
How do consume web service using VS.NET 2003 in VB: Hello.I'm using Visual Studio.NET Enterprise Architect 2003. I want to be able to request a web service using VB and have it return a message.I used the walkthrough "Accessing an XML Web Service Using Visual Basic or Visual C#" VB version to create my own project. Below is the...; Tags: consume web service, Microsoft Visual Basic, Microsoft Visual Studio.Net, Microsoft Visual Studio.Net 2003, programming, Simple Object Access Protocol, TonyGirgenti, Web, Web service, XML; Discussion threads 2006-02-13
Validator Form Works in Firefox but doesn't in IExplorer: I have a PHP form callinf a Validator Java Script. It works ok in Mozilla Firefox 1.5.0.9, but does in Internet Explorer 6.0.29It doesn't recognize any value on the form, then is complaining on the mandatory fields: so looks like Frm.elements[j].value is not valid in Intener Explorer, how I can...; Tags: alfonsoarias@..., windows, security, programming, Mozilla Firefox; Discussion threads 2007-02-05
SQL Server, Query Last month, always: I am trying to create a view in microsoft sql server 2005, where it pulls in invoice details for last month, i can use the between command and get it working just fine, but i have to change it every month, the view is used for a report that runs...; Tags: DatePart, GetDate, andresk@..., programming, Microsoft SQL Server; Q&A 2006-07-12
Inserting specific values into an identity column with SQL: Another reason to not use identity columnsThe fact that you can manually insert data into an identity column makes it, well, not an identity at all. That capability makes them totally useless for reducing exposure to legal liability or for financial auditing purposes. They just don't represent facts....; Tags: dalepres@..., identity column, identity column primary key sql server, pointer, software, SQL; Discussion threads 2005-08-18
Choose between server and client controls: ASP.NET Web Controls offer a robust set of controls to build Web-based applications. Learn how to use Web Controls to add search functionality to a Web form. The disconnected nature of Web browsers presents many obstacles when developing Web-based applications. For instance, loading data...; Tags: Web, HTML, Servers, Tony Patton, Channel management, Web Control, id, server, .NET Newsletter, Function, TechRepublic Inc., Control, Microsoft ASP.NET, JavaScript, Radio, WIDTH, HEIGHT, txtStartDate, txtEndDate, EventArgs, getEndDate, getSelection, ByVal, txtEndDate.Visible, txtStartDate.Visible, lblEndDate.Visible, lblStartDate.Text, showHide, getRadioStatus, Request.Form, rValue, Hardware; Technical articles 2005-06-30
Understand when to use user-defined functions in SQL Server: In the simplest terms, a user-defined function UDF in SQL Server is a programming construct that accepts parameters, does work that typically makes use of the accepted parameters, and returns a type of result. This article will cover two types of UDFs: table-valued and scalar-valued. (I will not be covering...; Tags: Function, Parameter, Microsoft SQL Server, Server, Value, Table, UDF, SalesHistory, SaleDate, SalePrice, Tim Chapman; Blog posts 2007-09-04
Using system variables in SQL Server 2005 Integration Services applications: The use of variables is vital to any type of program, and SQL Server 2005 Integration Services SSIS is no different. SSIS has been drastically improved over DTS in SQL Server 2000 to provide much better support for the use of variables. This tutorial describes how to use the built-in SSIS...; Tags: Database, Microsoft SQL Server, Auditing, Variable, SQL, Microsoft SQL Server 2005, System Variable, SSIS, Tim, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Tim Chapman; Blog posts 2007-11-12
Speed up SQL Server database queries with these tips: implement a search engine using phpI have all my lyrics in a database.It's a huge database witch is working slow, because of the large amount of rows >150.000 in db.So that's why i made static pages for my site, even if i take more space from HDD.But now i want...; Tags: Databases, sarki32@..., Microsoft SQL Server, database; Discussion threads 2007-09-11
Calculating project deviation: Calculating project deviationI have to decide how I am going to measure the project advance. I think that is better measure comparing with the plan at the measure moment and not comparing with the complete project because if I measure with the complete project may occur that I can think...; Tags: deviation, Microsoft Project; Q&A 2004-12-30

<< Previous
page 1 of 1
Next >>

Content Types

Discussion threads (2 results)

Q&A (1 results)

Network Administration in Windows Server 2003: While the role of a Windows network administrator would never be considered easy, you can lighten your load by knowing the ins and outs of Microsoft's ...; Buy Now

Cisco IOS Command Chart (IOS v.12+): Becoming proficient with Cisco equipment means remembering a whole new set of commands. These command charts give you a quick way to look up the needed IOS commands and switches when you need them.; Buy Now