Minimum of date

[Anonymous]

Hello, I would like to calculate from a date variable  "vDateDébut"  the smallest date

like this

i tried two formula but it doesn't work

min({<Date={"<$(=vDateDébut)"}>   Date)

min({<Date={"<$(vDateDébut)"}>   Date)

thank you for your help

[Anonymous]

please upload a sample...

[prma7799]

what expression you used for vDateDébut

Or please share sample app

[tresesco]

How is your variable defined? Try with a parenthesis correction, like:      

min({<Date={"<$(vDateDébut)"}>}  Date)

[arvind_patil]

Hi Saoud,

You Can try this;

Temp: 

Load 

               min(VALIDDATE) as minDate

Resident Facts; 

Let vDateDébut= Num(Peek('minDate', 0, 'Temp')); 

DROP Table Temp; 

[jmvilaplanap]

Hi

I think,this is the expression that you need:

• date(min({<date={"<$(=vDateDebut)"}>}date), 'DD/MM/YYYY')

But, be careful with the vDateDebut data format, I define the variable as:

• LET vDateDebut = date('03/01/2017', 'DD/MM/YYYY');

Because if not, the result of the first expression is null

Regards

[Anonymous]

an example

thanks

[Anonymous]

Hello,

Thanks but is dosesn't work, an example

Regards

[Anonymous]

an example

thanks

[Anil_Babu_Samineni]

I don't have license !! What you are declaring with variable