min date selection

[#1]

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

[Anonymous]

can u please attach ur app?

[pljsoftware]

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

PLJ Software

[perumal_41 · Accepted solution]

Hi Vijay,

use this expression.this expression slove ur problem.

min({1}date) as min_date

[jagan]

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.

[#6]

convert the date to number and then apply min function on it..or please attach ur application