Default Value for Parameter RRS feed

  • Question

  • hi all,

    I have a date parameter which accepts the following value:


    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



    Wednesday, June 16, 2010 11:07 PM


  • 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