How to choose format of date in Listbox ?

[Anonymous]

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 !

[Peter_Cammaert · Accepted solution]

Something like this?

[Anonymous]

Yes !

Thank you very much. the expression is clearer !