newbie format question

[Guest]

I am new to vb .net and struggling with expressions - I am using microsoft
sql reporting services and to customize *anything* there you need to
understand how to code vb .net expressions. I am getting there but there are
qwerky things that dont make sense to me. For instance ... can someone tell
me why this expressions works to return the month in name format (like June)

Format(DateAdd(DateInterval.Month, 0,Parameters!PM_START_DATE.value), "MMMM")

AND

this statement DOESNT work (uses Parameter field)

Format( Parameters!PM_START_DATE.Value , "MMMM")

BUT

this statement DOES work (uses database field)

Format( Fields!LCL_START_DATE.Value , "MMMM")


I am confused !! Thanks in advance and any places I can look for expression
help too

 

[Rick Mogstad]

I am new to vb .net and struggling with expressions - I am using microsoft
sql reporting services and to customize *anything* there you need to
understand how to code vb .net expressions. I am getting there but there
are
qwerky things that dont make sense to me. For instance ... can someone
tell
me why this expressions works to return the month in name format (like
June)

Format(DateAdd(DateInterval.Month, 0,Parameters!PM_START_DATE.value),
"MMMM")

AND

this statement DOESNT work (uses Parameter field)

Format( Parameters!PM_START_DATE.Value , "MMMM")

BUT

this statement DOES work (uses database field)

Format( Fields!LCL_START_DATE.Value , "MMMM")


I am confused !! Thanks in advance and any places I can look for
expression
help too

Have you checked what the value of your parameter is?

 

[Guest]

the value is 6/30/2005. It displays on the report properly as that ...
however I want it to display as June ... because rather than to say the
report is running for 6/1/2005 thru 6/30/2005 they want it to read "for the
month of June"