Skip to Content
0

Webi rolling date range query

Nov 01, 2016 at 04:23 PM

60

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Kuldeep Ghosh Nov 01, 2016 at 04:31 PM
0

Try using this condition:

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

Share
10 |10000 characters needed characters left characters exceeded