One month prior on tablix
-
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?
-
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
-
This works, but it adds a month, I was looking to subtract a month.
-
...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? -
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)
-
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