>Im trying to concatinate a string like so "???2000FEB.rep" while building the file name I ran across the following behaviour.
>When I issue a:
>
? format(month(date),"MMM")>I get
>
Jan>When I issue a:
>
? date()>I get:
>
2/28/00>So My system date isn't set for last month ... Whats up with this?
Don't extract the month before passing it to the format function (? format(date,"MMM"))
You should try this: ? "abc" & format(date,"yyyymmm") & ".rep"
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com