Confluence table filter - issue with date filter

[Nenad Ristevski]

Hi,

I am using Jira issues macro inside Table filter and have issue to properly filter table. Date format in Jira is like 08/Apr/25 . I am not sure what date format to use in the filter in order properly do filtering. I tried also with Table Transform, but result is the same.

In a dropdown filter of a macro I am not able to recognize this date format. Probably I missed something but need your help on how to set this right.

Thanks

[Stiltsoft support · Accepted solution]

Hi @Nenad Ristevski ,

Seems that you are talking about our Table Filter, Charts & Spreadsheets for Confluence app and its Table Filter macro.

Have you adjusted the date format when setting the Date range filter? Your filter shows 5/17/25 that is m/d/y and the format in your table is 18/Apr/25 that is dd/M/y.

[Nenad Ristevski]

Hi,

Thanks for your reply.

Here is how I set the filter:

And here is result:

It seems to me that there is no corresponding date format in filter macro for the one used in Jira: e.g. 08/Apr/25. Am I right?

If that's true, is there a way to transform it? I can also use Table Transformer.

Thanks.

[Stiltsoft support]

When you add the Date filter to the column, it prompts to type in the required Date format. As you have dd/M/y format in the original table, you should enter this format in the field.

[Nenad Ristevski]

Oh, my bad! Of course, this works! Thanks a lot!