Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, I have an example
The expresion is like this: =date(min({<Date={"<$(=vDateDébut)"}>}Date), 'DD/MM/YYYY')
And I changed your variable to date format
And it works
P.S. QV is Case Sensitive, be careful with the field names, your field is named "Date" not "date"
please upload a sample...
what expression you used for vDateDébut
Or please share sample app
How is your variable defined? Try with a parenthesis correction, like:
min({<Date={"<$(vDateDébut)"}>} Date)
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;
Hi
I think,this is the expression that you need:
But, be careful with the vDateDebut data format, I define the variable as:
Because if not, the result of the first expression is null
Regards
an example
thanks
Hello,
Thanks but is dosesn't work, an example
Regards
an example
thanks
I don't have license !! What you are declaring with variable