Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with a series of dates and would like to use the date picker to select only the min date and max date and display them in two separate columns. Below is the expression I am using. Currently my output in both columns is the dates between the min and max dates selected. How do I get it to only display the min in one column and max in the other?
({<POST_DT={'$(=Max(POST_DT))'}>})
({<POST_DT={'$(=MIN(POST_DT))'}>})
I don't fully understand what you want. Will this work? The second table just shows two measures with the min(date) and max(date). There are no selections currently, but if you make any, the min and max will change.
The second table would be my desired output. I would like to use the date picker to make the selection. What is the syntax to use the date picker selection?
So you want it to show the min and max dates from the dates you select? It should do this already:
Can I use the Date Picker
Yes. You will need to change the date picker to "range" instead of "single date" and it will let you select a range of dates. Then the table will show the min and max of those dates.