<div>
Kind of silly for the dates to be stored that way. &nbsp;Anyhow, use DateTime and TimeSpan. &nbsp;You have to parse the int, something like this:<br />
<br />
<br />

<pre><code id="code-8227002">const int SillyDate = 20111014;

int year = SillyDate / 10000;
int month = (SillyDate - year) / 100;
int day = month % 1000;

DateTime date = new DateTime(year, month, day);
TimeSpan span = new TimeSpan(31, 0, 0, 0);

if (DateTime.Now - span)
{
   // bingo
}</code></pre>
</div>


Kind of silly for the dates to be stored that way.  Anyhow, use DateTime and TimeSpan.  You have to parse the int, something like this:




const int SillyDate = 20111014;

int year = SillyDate / 10000;
int month = (SillyDate - year) / 100;
int day = month % 1000;

DateTime date = new DateTime(year, month, day);
TimeSpan span = new TimeSpan(31, 0, 0, 0);

if (DateTime.Now - span)
{
   // bingo
}

<div>
Change line 10 above to:<br />
if (date &gt;&nbsp;DateTime.Now - span &amp;&amp;&nbsp;date &lt;= DateTime.Now)<br />
<br />
...technically, you probably should also set a local var dateNow instead of using the .Now property twice.<br />
<br />
(Still don't know why I can't edit a post...)
</div>


Change line 10 above to:
if (date > DateTime.Now - span && date <= DateTime.Now)

...technically, you probably should also set a local var dateNow instead of using the .Now property twice.

(Still don't know why I can't edit a post...)

<div>
Hi Slimfinger,<br />
<br />
Line 8 killed me, Im working on VB instead of C#
</div>


Hi Slimfinger,

Line 8 killed me, Im working on VB instead of C#

<div>
<div class="content wysiwyg-content">
Hello all,<br />
<br />
I have a legacy database from where I retrieve a field (INT) that is supposed to be a date, in the format yyyyMMdd, for example 20111014 for today.<br />
<br />
What I need to know is if that date, let's say...<br />
<br />
Dim DBdate as integer = 20111014<br />
<br />
... is in between today minus 31 days range.<br />
<br />
Is this possible?<br />
<br />
Thanks!<br />
<br />
Paula
</div>
</div>


Hello all,

I have a legacy database from where I retrieve a field (INT) that is supposed to be a date, in the format yyyyMMdd, for example 20111014 for today.

What I need to know is if that date, let's say...

Dim DBdate as integer = 20111014

... is in between today minus 31 days range.

Is this possible?

Thanks!

Paula

Date in format yyyyMMdd

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications