Dream.In.Code > Programming Help > C#

Welcome to Dream.In.Code
	Become a C# Expert! Join 136,896 C# Programmers for FREE! Get instant access to thousands of C# experts, tutorials, code snippets, and more! There are 1,729 people online right now. Registration is fast and FREE... Join Now! Chat LIVE With a C# Expert

Returning the date a week ago

Reply to this topic

Start new topic

Returning the date a week ago, Returning the date a week ago

Rocket452	3 Apr, 2008 - 11:46 AM Post #1
New D.I.C Head Joined: 3 Apr, 2008 Posts: 10	I am trying to return the date a week ago from today. I am using: CODE System.DateTime.Now.ToShortDateString() to return the current date, so basically I want to return that - 7 days so that I can use the result as a parameter in a SQL query. I know that System.DateTime has a Subtract method but I dont think it will serve my purposes.
	This Post Was Helpful!


Register for Free to Make These Ads Go Away!

Martyr2	RE: Returning The Date A Week Ago 3 Apr, 2008 - 11:59 AM Post #2
Programming Theoretician Joined: 18 Apr, 2007 Posts: 5,231 Thanked: 220 times Expert In: C/C++, Java, VB, VB.NET, C#, PHP, Web Development, HTML & CSS, Javascript My Contributions	And why won't the subtract method work? Looks like it works to me... csharp // Get the time now System.DateTime theTime = System.DateTime.Now; // Create a time span object for 7 days System.TimeSpan timespan = new TimeSpan(7,0,0,0); // Subtract the span from the time theTime = theTime.Subtract(timespan); // Messagebox now shows time 7 days ago MessageBox.Show(theTime.ToString()); Then you can do what you will with the time object there in your query.
	This Post Was Helpful!

Rocket452	RE: Returning The Date A Week Ago 3 Apr, 2008 - 01:25 PM Post #3
New D.I.C Head Joined: 3 Apr, 2008 Posts: 10	Thank you this works well. I assumed the timeSpan object was a specific date so that why I didnt use it.
	This Post Was Helpful!

Martyr2	RE: Returning The Date A Week Ago 3 Apr, 2008 - 01:35 PM Post #4
Programming Theoretician Joined: 18 Apr, 2007 Posts: 5,231 Thanked: 220 times Expert In: C/C++, Java, VB, VB.NET, C#, PHP, Web Development, HTML & CSS, Javascript My Contributions	Timespan represents well... a span of time. In our example it represents the span of 7 days.
	This Post Was Helpful!

Fast Reply

Reply to this topic

Start new topic

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

Time is now: 12/3/08 09:25PM

Invision Power Board v2.1.7 © 2008 IPS, Inc.

Licensed to: MediaGroup1

Advertising | Terms of Use | Privacy Policy | About Us | Site Map

Forum Index: Programming Help | C and C++ | Visual Basic | Java | VB.NET | C# | ASP.NET | PHP | ColdFusion | Perl and Python | Ruby | Databases | Other Languages | Game Programming | Software Development | Computer Science | Industry News | Programming Tutorials | C++ Tutorials | Visual Basic Tutorials | Java Tutorials | VB.NET Tutorials | C# Tutorials | PHP Tutorials | Linux Tutorials | ColdFusion Tutorials | Windows Tutorials | HTML/JavaScript Tutorials | CSS Tutorials | Flash Tutorials | Web Promotion Tutorials | Photoshop Tutorials | Software Development Tutorials | Database Tutorials | Other Language Tutorials |

Copyright 2001-2008 MediaGroup1 LLC, All Rights Reserved
A MediaGroup1 LLC Production - Version 6.0.2.1.36

Search^Updated!w00t

Over 509,000 Pages! Advanced Forum Search

Live C# Help!

C# Tutorials

Reference Sheets

C# Snippets

DIC Chatroom

Join our IRC Chat

Bye Bye Ads

Monthly Drawing

Top Contributors

Top 10 Kudos This Month

sharpy (50)
KYA (50)