Kelly Martens

<div>
That VBA can be reduced to:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42730678-1"><span>// Days to add/deduct.</span>
<span>int numDaysBefore = 2;</span>
<span></span>
<span>mskFromDate.Text = DateTime.Today.AddDays(-numDaysBefore).ToShortDateString();</span>
<span>mskToDate.Text = DateTime.Today.AddDays(numDaysBefore).ToShortDateString();</span>
</code></pre>
</div>


<div>
TimeSerial is throwing me off...
</div>


<div>
Not sure what you mean - but the original code could have been reduced as well:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42730855-1"><span>mskFromDate.Text = Format(DateAdd(&quot;d&quot;, -iNumDaysBefore, Date), &quot;Short Date&quot;)</span>
<span>mskToDate.Text = Format(DateAdd(&quot;d&quot;, iNumDaysAfter, Date), &quot;Short Date&quot;)</span>
</code></pre>
</div>


<div>
You are missing something. That &quot;solution&quot; will add <b>NumDaysBefore * 24</b> days, not <b>NumDaysBefore </b>days.
</div>


<div>
<div class="content wysiwyg-content">
These two lines of vb6 code I am trying to translate to C#:<br />
<br />
mskFromDate.Text = Format(Date - TimeSerial((iNumDaysBefore<wbr /> * 24), 0, 0), &quot;Short Date&quot;)<br />
&nbsp; &nbsp; mskToDate.Text = Format(Date + TimeSerial((iNumDaysAfter * 24), 0, 0), &quot;Short Date&quot;)<br />
<br />
I have this so far. I know it is not right. <br />
<br />
var dt = string.Empty;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dt = Convert.ToString(DateTime.<wbr />Now.ToOADa<wbr />te() - (NumDaysBefore * 24));<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.dtFromDate.Text = Convert.ToDateTime(dt).ToS<wbr />hortDateSt<wbr />ring();<br />
<br />
Anybody have thoughts? I can't believe in vb6 they let folks subtract dates and numbers.
</div>
</div>


These two lines of vb6 code I am trying to translate to C#:

mskFromDate.Text = Format(Date - TimeSerial((iNumDaysBefore * 24), 0, 0), "Short Date")
    mskToDate.Text = Format(Date + TimeSerial((iNumDaysAfter * 24), 0, 0), "Short Date")

I have this so far. I know it is not right. 

var dt = string.Empty;
                dt = Convert.ToString(DateTime.Now.ToOADate() - (NumDaysBefore * 24));
                this.dtFromDate.Text = Convert.ToDateTime(dt).ToShortDateString();

Anybody have thoughts? I can't believe in vb6 they let folks subtract dates and numbers.

.NET and TimeSerial from vb6

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.