DZone Snippets: vbnet code http://snippets.dzone.com/posts Sat, 17 May 2008 15:19:57 GMT DZone Snippets: vbnet code Calculate Last Day of Last Month http://snippets.dzone.com/posts/show/5076 VB/VBA/VB.NET one-liner to calculate the end of last month. Useful for SSRS/RDL Expressions and Excel/Office Formulas. Note that it does not use string parsing, which can cause localization problems. <br /> <br /> <br /><code> <br />DateAdd("d", -1.0 * DatePart("d", Today), Today) <br /></code> Fri, 01 Feb 2008 22:51:12 GMT http://snippets.dzone.com/posts/show/5076 jokeyxero (xero) Calculate First Day of Current Month http://snippets.dzone.com/posts/show/5075 VB/VBA/VB.NET one-liner to calculate the start of the current month. Useful for SSRS/RDL Expressions and Excel/Office Formulas. Note that it does not use string parsing, which can cause localization problems. <br /> <br /><code> <br />DateAdd("D", -1.0 * DatePart("D", Today) + 1, Today) <br /></code> Fri, 01 Feb 2008 22:48:45 GMT http://snippets.dzone.com/posts/show/5075 jokeyxero (xero) Calculate First Day of Last Month http://snippets.dzone.com/posts/show/5074 VB/VBA/VB.NET one-liner to calculate the start of the previous month. Useful for SSRS/RDL Expressions and Excel/Office Formulas. Note that it does not use string parsing, which can cause localization problems. <br /> <br /><code> <br />DateAdd("D", -1.0 * DatePart("D", Today) + 1, DateAdd("m", -1, Today)) <br /></code> Fri, 01 Feb 2008 22:47:11 GMT http://snippets.dzone.com/posts/show/5074 jokeyxero (xero)