Re: Newbie: How to extract year from a Date object



"Newbie" <steve@xxxxxxxx> wrote in message news:GpVXe.812$hW.755@xxxxxxxxxx

> Year(myDate) is only for VBA.
> myDate.Year doesnt exist.

The Year function works fine in VBA, VB5 and VB6 on my system. Try:

MsgBox Year(Now)

Which version of VB are you using?

Mike



.



Relevant Pages

  • Re: Radial text on a path
    ... Access (VBA)? ... cannot be performed with standard VBA code, but I'm afraid that I can't help ... using VBA or are you using VB5 or VB6? ...
    (microsoft.public.vb.general.discussion)
  • Re: download the trial??
    ... VB6 OR VB5 OR VBA OR VBS ...
    (microsoft.public.dotnet.languages.vb)
  • Re: download the trial??
    ... VB6 OR VB5 OR VBA OR VBS ...
    (microsoft.public.dotnet.languages.vb)
  • Re: download the trial??
    ... VB6 OR VB5 OR VBA OR VBS ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Why to use VBA?
    ... all I am saying is its time to start introducing new features in .net that will do the same thing VBA does and give the market time to accept it without dropping VBA as you said executives are conservative to change VBA! ... The fact is that VB.NET is sufficiently incompatible with the previous version of VB (VB6, from which VBA is derived) that for all practical purposes an upgrade wasn't possible, you had to rewrite the code more or less from scratch. ... The automated code converters provided by Microsoft were next to useless, and the fact that Microsoft went and changed lots of names of objects and properties meant that late-binding code wouldn't work without rewrite because it couldn't be automatically converted at all. ... Lots of people asked Microsoft what that reason was, with regard to that and dozens of other changes to the language. ...
    (microsoft.public.word.vba.general)

Loading