Difference between created on and created relative after?

[rdoyle]

I'm putting together a report where I want to see the number of incidents over the last 6 months. If I put in the condition of "created on last 6 months" I get a different result than if I put in "created relative after 6 months ago". 

What's the difference between these? Which one should I be using?

[Allen Andreas · Accepted solution]

Hi,

Created relative after 6 months ago will use 6 months ago exactly from today's date and backwards 6 months.

Created on last 6 months will use the full month 6 months backwards 1-30 (for example).

As far as which one you should use...that's up to you and your requirements. Please review the above and use the appropriate one that makes sense to you. Thanks!

[Nia McCash]

I tested this with a shorter time frame and here's what I found... 

Starting from today's date and time - 2023-03-20 17:00:00

• Created on last 7 days shows tickets from created from 2023-03-13 00:00:00 and later
• Created relative after 7 days ago shows ticket created from 2023-03-13 17:00:00 and later

Note the time difference between the two options.

[rdoyle]

Thank you both, very helpful!