Skip to Content
0

Creating a "yesterday" dimension flag

Feb 09 at 12:27 AM

26

avatar image
Former Member

I am trying to create a dimension as an end user to flag dates that occurred the day prior to when the report runs. I have tried the below and then filtered the data to show "1" only however it will not return any results. I know I have [ED Arrival (Date)] with a date of yesterday. Any help would be greatly appreciated.

=(If ([ED Arrival (Date)] = (RelativeDate(CurrentDate();-1))) Then 1 Else 0)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
seshu P Feb 09 at 07:48 AM
0
Share
10 |10000 characters needed characters left characters exceeded