Date Year function

[monrosal]

Has anyone else had a problem using the Year function? I'm trying to do a Year(Now()), but it's giving me a weird year. Also when I try to get the 4 digit year using
Format(date, "MM/DD/YYYY&quot, it still gives me the 2 digit year with mm/dd/yy. Does anyone know how I can get the current 4 digit year? It should be simple, but it's driving me crazy.

Ramon

 

[JohnYingling]

Try "mm/dd/yyyy" instead of "MM/DD/YYYY". Format without a format functions as STR and since it may not recognize your uppercase format it may be ignoring it.

http://WWW.VBCompare.Com

 

[raskew]

Alernatively, forget the formatting and try this from the debug window:

? year(date())
2001