snipt

Ctrl+h for KB shortcuts

VB.net

SSRS VB / SQL get last day of month before previous

=DATEADD("d", - DAY( Now() ) ,DATEADD("m",-1, Now()))
https://snippets.siftie.com/embed/8c999ff9e8ff925d97aa8cb6f11c7850/
/raw/8c999ff9e8ff925d97aa8cb6f11c7850/
8c999ff9e8ff925d97aa8cb6f11c7850
vb.net
VB.net
1
2019-04-23T15:55:43
True
False
False
Dec 11, 2013 at 02:31 AM
/api/public/snipt/99773/
ssrs-vb-sql-get-last-day-of-month-before-previous
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="o">=</span><span class="n">DATEADD</span><span class="p">(</span><span class="s">&quot;d&quot;</span><span class="p">,</span> <span class="o">-</span> <span class="n">DAY</span><span class="p">(</span> <span class="n">Now</span><span class="p">()</span> <span class="p">)</span> <span class="p">,</span><span class="n">DATEADD</span><span class="p">(</span><span class="s">&quot;m&quot;</span><span class="p">,</span><span class="o">-</span><span class="mi">1</span><span class="p">,</span> <span class="n">Now</span><span class="p">()))</span> </span></pre></div> </td></tr></table>
SQL, SSRS, VB