Query between dates from now

Hi, i need a query to show the tickets created greater than 6 months and less than 1 year from now.

Thanks.

1 answer

0 votes

Answer accepted

I think is :

created >= startOfMonth(-12M) and created <= startOfDay(-6M)

Created in the las 12 month but before the las 6 months.

Regards, Marce

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Works fine, thank you very much.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.