How to show results within the past 30 days

JHaden3

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".

Jerry Casey

You could make a column using TIMESTAMPDIFF(SQL_TSI_DAY,"Worker"."Termination Date",CURRENT_DATE).  This will create a "Days Ago" column for termination date.

JHaden3

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

Jerry Casey

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

Something's amiss.

JHaden3

Thank you, I got it to work.