Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone
I want to sort date that is in the format of dd/mm/yyyy
How will i do it?
use the "Sort" tab in the object properties window.
You can sort the field based on several conditions.
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
go to sort tab
Select Numeric Value and do the sorting as per your require order... i.e. ascending or descending
goto Properties -->Numerb->Override Doc setting -->date -->format pattern -->dd/mm/yyyy
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,