store year as integer

[tbac]

I tried to store the current year as a long integer and it is not working so far. Can someone help me with the correct format? Here is what I did:

Dim myear As Long
myear = Year(Now())

 

[ZmrAbdulla]

Dim myear As Long
myear = CLng(Year(Now()))

Zameer Abdulla

 

[TheAceMan1]

How are ya tbac . . .

Perhaps:

[blue]   variablename = CLng(Year(YourDateHere))[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[ProgramError]

As a matter of interest, Why are you storing the date in an integer when there is a date type available and not using this negates you from using all the date functions ie dateadd() etc.

Just a thought.


Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.