Get the minimum date in a column using table filter

Question

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.

Stiltsoft support · Answer

Hi @Vijay Kumar Singhal ,

You may use the Table Transformer macro for the case:

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

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".