Post reply

One month prior on tablix

  • August 28, 2009 at 7:07 am

    #213876

    I have a report that has a tablix control. I have been asked to take one date column and make it one month prior to another date column.

    I have an expression already on these two date columns to format the date..Here's the expression:

    =Format(CDate(Fields!ARM_Next_Rate_Change_Date.Value),"yyyyMMdd")

    How do I automatically make the date from this column one month prior to date in another column?

  • August 28, 2009 at 8:41 am

    #1046272

    Use the below expression

    =DateAdd(DateInterval.Month, 1, Fields!Date1.Value)

    Hope it will help you

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • August 28, 2009 at 9:50 am

    #1046324

    This works, but it adds a month, I was looking to subtract a month.

  • August 28, 2009 at 10:17 am

    #1046334

    ...make that 1 a -1?....

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • August 28, 2009 at 11:14 am

    #1046352

    Cool the minus 1 worked...but now my problem is that I already have this expression to format the date:

    =Format(CDate(Fields!Next_Payment_Due_Date.Value),"yyyyMMdd")

    How can I use both of these together? Is it possible?

    =DateAdd(DateInterval.Month, -1, Fields!Next_Payment_Due_Date.Value)

  • August 31, 2009 at 12:29 am

    #1046734

    Use this

    =Format(CDate(DateAdd(DateInterval.Month, -1, Fields!Next_Payment_Due_Date.Value)),"yyyyMMdd")

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

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

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