I am getting errors when I use calculations with Dates

Andy Smith

(11●1●1) May 23 '13, 9:06 a.m.

Hi,

I am new to RI and am currently trying to put together some sample reports for management. I am using a table that has a daily feed to it and is identified by Load_Date. I want to run a report using the previous days data and have tried using the filter expression Load_Date='current_date' - 1, but I keep getting an error message when it runs. Can someone help please.

Andy

0 votes

1 answer

4,345 views

0 votes

One answer

Permanent link

Jackie Albert

(1.6k●1●49●47) May 23 '13, 9:59 a.m.

I don't think straight subtraction on a date will work, but try using this expression:

_add_days(current_date, -1)

0 votes

Your answer

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers

Answers and Comments

Question details

usage

× 12,016

rational-insight

× 1,230

Question asked: May 23 '13, 9:06 a.m.

Question was seen: 4,345 times

Last updated: May 23 '13, 9:59 a.m.

I am getting errors when I use calculations with Dates

Andy Smith

1 answer

4,345 views

0 votes

One answer

Jackie Albert

Your answer

Follow this question

Question details

Related questions