It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×11,990
×1,235

question asked: May 23 '13, 9:06 a.m.
question was seen: 4,178 times
last updated: May 23 '13, 9:59 a.m.

Related questions

I am getting errors when I use calculations with Dates

0
Andy Smith (11●1●1) | asked 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

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Jackie Albert (1.6k●1●49●47) | answered 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)




Your answer

Register or to post 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.