question

[#1]

Hi everyone

I want to sort date that is in the format of dd/mm/yyyy

How will i do it?

[Anonymous]

use the "Sort" tab in the object properties window.

You can sort the field based on several conditions.

[nizamsha]

if you want to sort date in the script itself mean

suppose eg:

table1:

load * inline [

date

1/2/2012

1/1/2012

];

table2:

load date resident table1 order by date;

y i am creating date in another table mean u cant use order by in current table,order by can be used in resident table only

now u will get the date like this

1/1/2012

1/2/2012

or

if u want date  ascending or descending in listbox mean u can go to sort tab in your listbox in that u can use ascending or descending

[MK_QSL]

go to sort tab

Select Numeric Value and do the sorting as per your require order... i.e. ascending or descending

[NavinReddy]

goto Properties -->Numerb->Override Doc setting -->date -->format pattern -->dd/mm/yyyy

[v_iyyappan]

Used the dimension like this

if you are datedim as month use the script

Dual(Date(Datefield, 'dd/mm/yyyy'), monthstart(Datefield)) as datedim

or

Dual(Date(Datefield, 'dd/mm/yyyy'), daystart(Datefield)) as datedim

give the dimension datedim in desired charts and sort tab ----> numeric -----> asc

regards,