Skip to Content
avatar image
Former Member

Creating a "yesterday" dimension flag

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 09 at 07:48 AM
    Add comment
    10|10000 characters needed characters exceeded