VB.NET Get Only Year from Date

Question

I'm pulling into a variable a datetime value. Now, I want to post this value back to my database, but I need it to be only the year digits. How do I get VB.NET to trim the month, day, and time off and just return the four character year (e.g. 2011)?

Solution 1

Date.Today.Year is what you're looking for, or for an existing date, just someDateVariable.Year

Solution 2

Dim myDate As DateTime = #1/1/2011#
Dim myYear As Int32 = myDate.Year

Solution 3

i know this is a bit late to answer but, it wont hurt telling, try "year(now) " and load it to a variable Example:

Dim Year_in_Digits = Year(Now)

Solution 4

I just had to do this for my VB program.

 Dim Year As Integer    
 Year = Convert.ToInt32(Now.ToString("yyyy"))

Use just "yy" if you want two digit year. Then, when you need to display it somewhere:

year.tostring

Solution 5

There is a property on the DateTime structure called 'Year'. This returns an integer representing just the year.

If you need to convert this to a string, just use the ToString() function.

So..

MyDT.Year.ToString()

That's a c# example, I'm sure VB.Net is going to be very similar.

View more solutions

Comments

[Dave Mackey]

I get the message: "Year is not a member of 'System.Linq.IQueryable(Of Date?)"

[Dave Mackey]

I figured it out, I needed to make it: getYear.First.Value.Year