Format(Now(), "yyyymm") shows minutes instead of months?

Just ran into a strange error.
I want to see what year and month it is today, like 200411 for November,
2004. I've added a textbox to show this, and set the value to
="Month: " & Format(Now(), "yyyymmmm")
For some reason, this shows 200430, because the time is 09.30 on my
computer. I've tried with m, mm, mmm and mmmm, and it just shows the
minutes. Why?
I tried using VBA!Now() but then I get an error saying "VBA is not
declared". Where do I need to declare it?
Running VS.NET 2003 with the Report Designer installed. The Report Server is
Ent. edition, and it shows the same error when I upload the report.
Any help appreciated!
Kaisa M. LindahlTry "yyyyMMMM".
A really good page for all .NET format code is:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconformattingtypes.asp
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
news:ePUM8bjxEHA.1392@.tk2msftngp13.phx.gbl...
> Just ran into a strange error.
> I want to see what year and month it is today, like 200411 for November,
> 2004. I've added a textbox to show this, and set the value to
> ="Month: " & Format(Now(), "yyyymmmm")
> For some reason, this shows 200430, because the time is 09.30 on my
> computer. I've tried with m, mm, mmm and mmmm, and it just shows the
> minutes. Why?
> I tried using VBA!Now() but then I get an error saying "VBA is not
> declared". Where do I need to declare it?
> Running VS.NET 2003 with the Report Designer installed. The Report Server
is
> Ent. edition, and it shows the same error when I upload the report.
> Any help appreciated!
>
> Kaisa M. Lindahl
>|||USE Format(Now(), "yyyyMM")
"Kaisa M. Lindahl" wrote:
> Just ran into a strange error.
> I want to see what year and month it is today, like 200411 for November,
> 2004. I've added a textbox to show this, and set the value to
> ="Month: " & Format(Now(), "yyyymmmm")
> For some reason, this shows 200430, because the time is 09.30 on my
> computer. I've tried with m, mm, mmm and mmmm, and it just shows the
> minutes. Why?
> I tried using VBA!Now() but then I get an error saying "VBA is not
> declared". Where do I need to declare it?
> Running VS.NET 2003 with the Report Designer installed. The Report Server is
> Ent. edition, and it shows the same error when I upload the report.
> Any help appreciated!
>
> Kaisa M. Lindahl
>
>|||Using MM instead of mm|||Tried this, and it works.
Thanks to all who answered. And for the url too.
Kaisa
"David Hughes" <spamfree@.freespam.com> wrote in message
news:uFg6$NkxEHA.1400@.TK2MSFTNGP11.phx.gbl...
> Try "yyyyMMMM".
> A really good page for all .NET format code is:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconformattingtypes.asp
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
> news:ePUM8bjxEHA.1392@.tk2msftngp13.phx.gbl...
> > Just ran into a strange error.
> > I want to see what year and month it is today, like 200411 for November,
> > 2004. I've added a textbox to show this, and set the value to
> > ="Month: " & Format(Now(), "yyyymmmm")
> >
> > For some reason, this shows 200430, because the time is 09.30 on my
> > computer. I've tried with m, mm, mmm and mmmm, and it just shows the
> > minutes. Why?
> >
> > I tried using VBA!Now() but then I get an error saying "VBA is not
> > declared". Where do I need to declare it?
> >
> > Running VS.NET 2003 with the Report Designer installed. The Report
Server
> is
> > Ent. edition, and it shows the same error when I upload the report.
> >
> > Any help appreciated!
> >
> >
> >
> > Kaisa M. Lindahl
> >
> >
>