Post reply

Report Parameters

  • August 25, 2009 at 1:10 am

    #213736

    I need a default Values of Date formulars for "Month" and "Year" as some of my parameters in my report.

    e.g. In my Date formular "Day" parameter is also one of my report parameters and I have a formular that works perfect for this parameter to give me the previous date day "=DateAdd(DateInterval.Day, -1, Today)"

    Please assist me with current "Month" and "Year" formular

    Your assistance will be gladly accepted

  • August 26, 2009 at 2:36 am

    #1044753

    You can use the DatePart function to extract components of a date.

    See here

    Nigel
    How to post questions

  • August 26, 2009 at 4:57 am

    #1044769

    or is the question -

    how do i get current date i.e select getdate() ?

    Ells.

    😎

  • August 26, 2009 at 8:03 am

    #1044876

    you can use MONTH and YEAR function.

  • August 27, 2009 at 1:47 pm

    #1045838

    Try this:

    Month(Parameters!MyDate.Value)

    Year(Parameters!MyDate.Value)

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply