Sorting Problem

[Rushhour]

Hi

I created 3 fields, DateExpire, DateCreate and DomainName in List view.

I create an additional 2 fields called year[Year(ExpiryDate)] and month[MonthName(ExpiryDate)] to group all the domain expiring on the same month and year together. E.g.

Date Expire Date Create Domain Name

2006 January

01/01/2006 01/01/2005 abc.com

2006 February

02/01/2006 01/01/2005 def.com

02/02/2006 02/02/2005 ghi.com

And now i having a problem, if i sort by month it may give me 2005 jan then 2004 feb then 2006 march. And if sort by year first it also having this type of problem.

How can i sort by year and month together??

Thanks a lot in advance.

Kelvin

[aaa]

Hi, Roshhour! You can sort by two criterias: Year,Month specifing it in sort options or: why you dont want sort by date?

[Rushhour]

Hi

I did tried using both fields 'year' and 'month' but still the same.

Attached is the sample file, can someone help me look into it.

Layout: Expired List

Script: Go to preview layout

Thanks a lot.

Kelvin

Domain_Name_Registry_Copy_testing.zip

[aaa]

Hi, Roshhour!

Your month field returns monthname and i think that this is the main reason of your problem. Create one other field month1=Month(ExpireDate) and sort by year and month1.

I did it in your attachment.

Domain_Name_Registry_Copy_testing.zip

[Rushhour]

Hi aaa

When i go to the expired list layout, all records are under january category. It is not categorise in their months..

Thanks a lot..

Kelvin

[aaa]

I see at me such, and i think that your script works right.This is word document.

Word.zip

[Rushhour]

Oh sorry maybe i never explain it clearly.

I wish to achieve date able to categorise by month. At the moment all dates are under january which is wrong, as september should not categorise under january.

E.g.

January

01/01/2006

01/02/2006

01/03/2006

Feburary

02/01/2005

02/01/2004

April

04/01/2005

Thanks a lot

Kelvin

[aaa]

Hi, Roshhour!

I attached file. On the Expired list layout i puted button sort. Such? Look please.

Domain_Name_Registry_Copy_testing.zip

[Rushhour]

Hi aaa

Thanks a lot for the help offered. I have managed to figure it out, attached is what i meant. Apologise maybe i still did not explain it clearly.

Thanks a lot

Kelvin

Domain_Name_Registry_Copy_testing.zip

Edited February 6, 2006 by Guest