Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I need your help about date format in listbox. It sounds easy but ...
I have a field "date_N" and I want to display this field in my listbox but i want to specify format according the value.
I want to display format DD/MM/YYYY for last 3 months and current month but only MM/YYYY for other value.
My expression works but it doesn't display a list...
Here is my expression (NB: actually i don't use variable because i am trying to test) :
if(num(month(date_N))>=num(Month(Max({1}date_N)))-3 and num(month(date_N)<=num(Month(Max({1}date_N))),date_N, date(date_N,'MM/YYYY'))
Thanks in advance for your help !
Something like this?
Something like this?
Yes !
Thank you very much. the expression is clearer !