Report Builder Month Function

0
votes

In report builder how to filter a date field to get the current month? I'm looking for something equivalent to the Today() function (that gets you just today values).

Actually when I use =field.date.value(Today()), I get today date returned. I would like something like that for the current month instead of the current date.

1
reportbuilder3.0

1 Answers

0
votes

Try this ,where i am getting the month value from the date of birth field.

=Cstr(Month(Fields!DOB.Value))