Dear BI Experts,
I have to calculate the number of days between an employee's Service data and the end of the pay period which is 12/27/2009.
I have the employee's service data pulled up from the Infoprovider and is a column (say column 10) in the report.
Now I want to create a new column (say column 11) in the report which would indicate a fixed value of the date 12/27/2009 so that I could create another column (say column 12) which will calculate the number of days between column 11 and column 10.
Could you please suggest as to how to hardcode the date 12/27/2009 in the column 11 for each row (employee).