datepart problem, yy

[Stefanw]

Hi,

I want to appear the last 2 digits of the year. for example "07".

Now I am trying this with datepart, but it gives me an error, while opening my report.

what's wrong??

Thanks


year = DatePart("yy", date)

this one works:

Year = DatePart("yyyy", date)
but it gives me the full year (2007)

 

[boblarson]

Just use

Format(Date,"yy")