DateTime

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bbawa1@yahoo.com - 25 Jun 2007 21:26 GMT

Hi,

I have a column of datatype DateTime. I need to retrieve data from
last 14
days old.

I am doing like this but it doesn't work.

Select reveiveddate from table1
where receiveddate = GetDate()-day(14)

Reply to this Message

Braulio Diez - 26 Jun 2007 07:30 GMT

If you date is a DateTime Object (no string, no...), you can use:

DateTime yesterday = DateTime.now();

yesterday.AddDays(-14);

You can use as well AddMonths, ...

Good Luck
Braulio

/// ------------------------------
/// Braulio Díez
///
/// http://www.tipsdotnet.com
/// ------------------------------

> Hi,
>
[quoted text clipped - 6 lines]
> Select reveiveddate from table1
> where receiveddate = GetDate()-day(14)

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...