Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I want to select minimum of the date from 'date' field.
I have tried it from the below expn:
min(date) as min_date
but the problem is it changes with the selection.
So how to select minimum date irrespective of date selection.
any suggestions
Hi Vijay,
use this expression.this expression slove ur problem.
min({1}date) as min_date
can u please attach ur app?
Hi,
where do you want to select min(date)? What do you make to do?
If you want to get a variable with the value of min(date) do you make this:
Variables:
Load
min(fieldDate) as min_date
,max(fieldDate) as max_date
Resident FactsTable;
LET vMinDate= Floor(Peek('min_date'));
LET vMaxDate = Floor(Peek('max_date'));
Drop Table Variables;
I hope this help you.
Regards
Luca Jonathan Panetta
Hi Vijay,
use this expression.this expression slove ur problem.
min({1}date) as min_date
Hi,
AS Perumal said, just create a variable with this expression
=min({1}date)
Since {1} ignores all selections.
Hope this helps you.
Regards,
Jagan.
convert the date to number and then apply min function on it..or please attach ur application