How to show results within the past 30 days

Question

I'm  new to OTBI.  I have an analyses where I want to return data for all employees termed within the past 30 days.  I want it show terminations 30 days ago, 29 day ago, 28 days ago down to 1 day ago.  How can I apply a filter or formula that will do this?  The field is "Worker"."Termination Date".

JHaden3 · Answer

Thank you, I got it to work.

Jerry Casey · Answer

If functioning correctly, that function would just return the number of days between each term. date and the current date.

Something's amiss.

JHaden3 · Answer

Good idea and thank you!  However, that returned only the date of the termination instead of a day count.