Relative Date in SSRS

Question

Hi

I am trying to create a relative date calculated column which is a difference between dataset last refresh date and a date column. This column is already being calculated in SAP BO with below formula
= RelativeDate(lastExecutionDate(), [Date Column], DayPeriod)

tried using DateAdd function in SSRS but did not work. Any suggestions....

Thanks in advance

Answer 1

Hi @Learner DAX ,

Suppose that you want to calculate the number of days between the date with last execution Date.

Try with below expression:

=DateDiff("d",Fields!ExecutionDate.Value,Fields!YourDate.Value)  

If I misunderstand your need, please incorrect me.

Regards，
Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

What can I do if my transaction log is full?--- Hot issues November

How to convert Profiler trace into a SQL Server table -- Hot issues November