SORT DD-MM

[Honki]

Hi!

I have my date(DD-MM) i want to use in my bar chart,  as you can see in the screen.

I would like to sort it.

Thanks in advance!

[brunobertels]

Hi 

To get the right sorting order use dual() function 

[MarcoWedel]

how did you create these dates?

[Honki]

Hello!

I wrote this Date(A,'DD-MMM'),  where A is my date field.

[Honki]

Can you show me exactly how to do, plz?

after writing dual( month(A), day(A)), then???

Thanks in advance!

[brunobertels]

Hi 

I assume your date format for field A is somethink like this by default DD-MM-YYYY

for example 05-01-2022 

in your graph you writed as date dimension this 

date(A,'DD-MMM') to get this date format 25-avr. ; 28-mai ; 16- juin etc 

then without order parameter you get wrong order in X abscisse like that : 

So if your field A for date is well recognise as an integer in format DD-MM-YYYY just select in order panel order by number : 

You can also force the order with dual function like that : 

dual(date(DATE_JOUR,'DD-MMMM'),num(DATE_JOUR)) 

for you : 

dual(date(A,'DD-MMMM'),num(A))

add this mesure in the panel option under order // order by expression // ascending 

regards 

[Honki]

It doesnt work!

I did what you said and i got this below:

1.Date(A, 'DD-MMMM')

2.dual(Date(A, 'DD-MMMM'),Num(A)) in sorting by expression

[brunobertels]

Hi 

What is your date format from field A ?

can you provide an exemple