Skip to Content

Webi rolling date range query

Hi

I have a requirement to build a query in Webi to show any employees who leff the organisation in the past 24 months. The report is to be rolling which means at any point when the report runs it needs to count back 24 months and show the names of the staff who left. Can anyone help me with the query I need to build to count back 24 months on a rolling basis?

Thanks

Will

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 01, 2016 at 04:31 PM

    Try using this condition:

    = [Resignation date] between(Min(RelativeDate(CurrentDate()); -24; MonthPeriod));currentdate())

    Add comment
    10|10000 characters needed characters exceeded