Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Get the minimum date in a column using table filter

Vijay Kumar Singhal
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 26, 2024

I have a table with columns of Start Date and End Date. Based on the column I want to fetch Minimum date in Start Date Column and Maximum date in End Date column. I used table filter macro with column calculation and min and max but the values are displayed in integer instead of date format in Total Row.

Screenshot 2024-03-27 at 10.19.08 AM.png

1 answer

2 votes
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 27, 2024

Hi @Vijay Kumar Singhal ,

You may use the Table Transformer macro for the case:

Wed 12-1.png

SELECT
MIN('Start Date') as 'Min Start Date',
MAX('End Date') as 'Max End Date'
FROM T*

Wed 12-2.png

The date format in the Settings tab of the macro should match the format that you have in your table. For example, for my case it's "dd M yy".

 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events