Order By date not working

[#1]

I tried order by date and it's not working is there any other way to sort that column.

Eg.

LOAD Name,Address,Birthday

Resident Details

Order By Name,Birthday desc;

I want the table to load the latest date data first.

Birthday format is in  DD/MM/YYYY

Thank you.

[alexandros17]

Try this

LOAD Name,Address,Birthday

Resident Details

Order By Name,Num(Birthday) desc;

[MK_QSL]

LOAD Name,Address,Date(Birthday) as Birthday

Resident Details

Order By Name,Date(Birthday) desc;

[MarcoWedel]

Hi angellineeee,

at first please check that your DateFormat is set correctly in your load script.

In our case it should be:

SET DateFormat='DD/MM/YYYY';

Otherwise try:

LOAD Name,Address,Date#(Birthday, 'DD/MM/YYYY') as Birthday

Resident Details

Order By Name,Date#(Birthday, 'DD/MM/YYYY') desc;

regards

Marco

[jagan]

Hi,

I think you need to format the date like this before ordering, currently your date field is considering as string.

Eg.

LOAD Name,

Address,

Date(Date#(Birthday, 'DD/MM/YYYY')) AS Birthday

Resident Details

Order By Name, Date#(Birthday, 'DD/MM/YYYY') desc;

Regards,

Jagan.

[martinpohl]

is it right to order by name, birthday?

This means each name has different birthday which need to be ordered.

Regards