Urgent date question

[Dinçer]

I need to compare dates. But this way:

I get a date from database.
I need to understand if this date is newer then "6 months" or not.

What I need is get the current date,
calculate the date 6 months ago,
compare "the date from DB" & "the date 6 months ago from now"
show the result.

How will I do that using DateTime or TimeSpan classes?

[Andreas Håkansson]

The different Add-methods on the DateTime class accepts negative
values. To subtract 6 months of the current date, you would do like this

DateTime today = DateTime.Now;
DateTime then = today.AddMonths(-6);

The variable 'then' will now contain the date you are looking for.

HTH,

//Andreas

"Dinçer" <dincer80"at"yahoo.com> skrev i meddelandet
news:%2****************@TK2MSFTNGP09.phx.gbl...

I need to compare dates. But this way:

I get a date from database.
I need to understand if this date is newer then "6 months" or not.

What I need is get the current date,
calculate the date 6 months ago,
compare "the date from DB" & "the date 6 months ago from now"
show the result.

How will I do that using DateTime or TimeSpan classes?

[Dinçer]

Thank you.
One last question:

The type of the date I get from DB is String.
How can I convert it to DateTime. (So that I can make the comparison)

DateTime constructer has no String argument. How will I do this?


"Andreas Håkansson" <andy.h (at) telia.com> wrote in message
news:uK**************@TK2MSFTNGP11.phx.gbl...

The different Add-methods on the DateTime class accepts negative
values. To subtract 6 months of the current date, you would do like this

DateTime today = DateTime.Now;
DateTime then = today.AddMonths(-6);

The variable 'then' will now contain the date you are looking for.

HTH,

//Andreas

"Dinçer" <dincer80"at"yahoo.com> skrev i meddelandet
news:%2****************@TK2MSFTNGP09.phx.gbl...

I need to compare dates. But this way:

I get a date from database.
I need to understand if this date is newer then "6 months" or not.

What I need is get the current date,
calculate the date 6 months ago,
compare "the date from DB" & "the date 6 months ago from now"
show the result.

How will I do that using DateTime or TimeSpan classes?

[Andreas Håkansson]

Dinçer,

The DateTime structure has two static members which should be of
intresst to you. They are DateTime.Parse() and DateTime.ParseExact(),
and I recommend you read the documentation for them.

HTH,

//Andreas

"Dinçer" <dincer80"at"yahoo.com> skrev i meddelandet
news:Of*************@TK2MSFTNGP12.phx.gbl...

Thank you.
One last question:

The type of the date I get from DB is String.
How can I convert it to DateTime. (So that I can make the comparison)

DateTime constructer has no String argument. How will I do this?


"Andreas Håkansson" <andy.h (at) telia.com> wrote in message
news:uK**************@TK2MSFTNGP11.phx.gbl...

The different Add-methods on the DateTime class accepts negative
values. To subtract 6 months of the current date, you would do like this

DateTime today = DateTime.Now;
DateTime then = today.AddMonths(-6);

The variable 'then' will now contain the date you are looking for.

HTH,

//Andreas

"Dinçer" <dincer80"at"yahoo.com> skrev i meddelandet
news:%2****************@TK2MSFTNGP09.phx.gbl...

I need to compare dates. But this way:

I get a date from database.
I need to understand if this date is newer then "6 months" or not.

What I need is get the current date,
calculate the date 6 months ago,
compare "the date from DB" & "the date 6 months ago from now"
show the result.

How will I do that using DateTime or TimeSpan classes?

[Dinçer]

OK.

Thank you..
"Andreas Håkansson" <andy.h (at) telia.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Dinçer,

The DateTime structure has two static members which should be of
intresst to you. They are DateTime.Parse() and DateTime.ParseExact(),
and I recommend you read the documentation for them.

HTH,

//Andreas

"Dinçer" <dincer80"at"yahoo.com> skrev i meddelandet
news:Of*************@TK2MSFTNGP12.phx.gbl...

Thank you.
One last question:

The type of the date I get from DB is String.
How can I convert it to DateTime. (So that I can make the comparison)

DateTime constructer has no String argument. How will I do this?


"Andreas Håkansson" <andy.h (at) telia.com> wrote in message
news:uK**************@TK2MSFTNGP11.phx.gbl...

The different Add-methods on the DateTime class accepts negative
values. To subtract 6 months of the current date, you would do like this
DateTime today = DateTime.Now;
DateTime then = today.AddMonths(-6);

The variable 'then' will now contain the date you are looking for.

HTH,

//Andreas

"Dinçer" <dincer80"at"yahoo.com> skrev i meddelandet
news:%2****************@TK2MSFTNGP09.phx.gbl...
> I need to compare dates. But this way:
>
> I get a date from database.
> I need to understand if this date is newer then "6 months" or not.
>
> What I need is get the current date,
> calculate the date 6 months ago,
> compare "the date from DB" & "the date 6 months ago from now"
> show the result.
>
> How will I do that using DateTime or TimeSpan classes?
>
>

[Jon Skeet [C# MVP]]

<"Dinçer" <dincer80"at"yahoo.com>> wrote:

The type of the date I get from DB is String.

Along with the other answers you've received, I have to at least
suggest that if you have any control over the database whatsoever, then
you change the type of the column to be a date type. It will make your
life *far* easier. I realise you may not have control over the
database, but if you do, it's definitely something to think about
changing.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too