duedate < endOfDay(20220731)

[Petra Liedel]

Hello

I want to samble all tickets of a month, f.e. all until 31.7.2022 (swimlane)
and then all until 31.08.2022 (swimlane)

I took endofdate but it doesn't work.

Voukd you help?

THANKS

[Fabio Racobaldo _Catworkx_ · Accepted solution]

Hi @Petra Liedel ,

please try the "endOfMonth()". Moreover, please kepp in mind that parameters are a numeric value

• endOfMonth() - end of current month
• endOfMonth(1) - end of next month
• endOfMonth(-1) - end of previous month

Hope this helps,

Fabio

[Petra Liedel]

thankyou very much :-)
but

is it possible to take a date or other ideas for getting all in sept, oct aso

endofdate (20220831)

endofdate (20220930)

endofdate (20221031)

sorry ;-)

[Fabio Racobaldo _Catworkx_]

Hi @Petra Liedel ,

you can use specific dates based on your date format.

Please try : 

duedate < "2022/07/31"

[Petra Liedel]

such great!!!!!!!!!

every day a good act - Thank you so much

[Fabio Racobaldo _Catworkx_]

you are welcome @Petra Liedel . Please mark my answer as accepted

[Petra Liedel]

just done ;-)

[Fabio Racobaldo _Catworkx_]

please click on "Accept answer" :) ... it is unresolved