locked
Default Value for Parameter RRS feed

  • Question

  • hi all,

    I have a date parameter which accepts the following value:

    [Date].[Date].[Month].&[201001]

    How can I default this to the 1st of the prior month (so report run June 3rd from date would be 1st May)

    please help me

    thanks

     

    Wednesday, June 16, 2010 11:07 PM

Answers

  • hello,

    this should work:

    =dateserial(year(today), month(today)-1, 1)

    • Marked as answer by Challen Fu Thursday, June 24, 2010 2:02 AM
    Wednesday, June 16, 2010 11:46 PM