Getting part of a date 2

[Apollo13a]

Hi, I'm trying to set a date variable equal to just the year of my returned date.

some DAO to get the date info then

LaborYear = !LaborDate
  LaborYear = DatePart("yyyy", !Labordate)

My code gets the proper date but I'm having trouble extracting the year Can someone point me in the right direction.

Jim

 

[Apollo13a]

Well, it seems I've found a solution but I'm wondering if it is the best way to go. I changed the data type of LaborYear to string and then using

LaborYear = Format(!LaborDate, "yyyy")

i get just the year

jim

 

[CaptainD]

try making the variable a string instead of a date.

Dim sLaborYear as string

sLaborYear = Datepart("yyyy", !LaborDate)
Msgbox sLaborYear

 

[Zion7]

Why not make it an integer and use,

intLabourYear = Year(!LabourDate)

 

[MajP]

It depends what are you trying to do. Why do you need a variable with the year value? You already know the year why do you need to store it as a variable? The solutions above may work. You have solutions that produce a string or an integer, but none are a "year". So you may find that you need to convert back to do any type of calculations or comparisons. Remember regardless of how a date is displayed all dates and times are stored the same way.