How do I calculate a month from current date in VB.NET?

Question

0.00/5 (No votes)

See more:

I have a program that will run on the 1st of the month. Then it will create a report of documents from last month.
For example, if it runs today (2018-04-09T11:35:58), it will go back and get documents only for the month of March from March 1st until March 31.
Currently the program is looking in a xml file for

HTML

<LastRunDateTime>2018-04-09T11:35:58</LastRunDateTime>

to get documents report.
I do not want to have this hard coded date in config file.
Every time my program runs, it is updating the config file's LastRunDateTime to currentDateTime.
Here is how I am doing this updating

VB

UpdateConfigFile with current date
objXmlTaskConfigDoc.DocumentElement.SelectSingleNode("LastRunDateTime").InnerText = dtmCurrentDateTime.ToString("yyyy-MM-ddTHH:mm:ss")

How can I do this without using hard coded date in config file? I want to skip the config file and calculate datetime inside my vb.net code. That is last months report regardless of the date the program runs. If it runs on April 15th, it should still get report of the month of March from March first until March 31st.

What I have tried:

The config file has this element which is updated by the following line of code

XML

<LastRunDateTime>2018-04-09T11:35:58</LastRunDateTime>

VB

'UpdateConfigFile with current date
objXmlTaskConfigDoc.DocumentElement.SelectSingleNode("LastRunDateTime").InnerText = dtmCurrentDateTime.ToString("yyyy-MM-ddTHH:mm:ss")

Posted 9-Apr-18 6:55am

Member 11403304

Updated 9-Apr-18 8:09am

Patrice T

v3

Add a Solution

Comments

Richard MacCutchan 9-Apr-18 12:56pm

If you do not have the date in the config file then how do you decide which months data to process?

MadMyche 9-Apr-18 13:21pm

You could always use an external DAT file for this

Member 11403304 9-Apr-18 13:34pm

The report is based on customer request. So a customer can requested a report for the Month of March. So when my program run (it is not running yet but in the future), it will get data from the database using a sql query that I have but then it will only give a report in form of a spreadsheet (this is done) for dates e.g. March 1st - March 31st or September 1 - September 30 etc.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RickZeeland · Accepted Answer · 2018-04-09T08:10:00

Solution 1

See .Month property: DateTime.Month Property (System)[^]

And .DaysInMonth() method: DateTime.DaysInMonth Method (Int32, Int32) (System)[^]

Posted 9-Apr-18 8:10am

RickZeeland