Sort in Query

[zyus]

I have problem to sort below field in my query.([fstrlsedt]-date field

RelMthYr: Format([fstrlsedt],"mmm-yyyy")

I expect to get Jan-2009,Feb-2009 & so on...but turned out to be
Apr-2009,Aug-2009,Jul-2009....

Thanks

 

[KARL DEWEY]

Formating builds a string (text) and it then performs an alpha sort.

Use second field for sorting --
SortMthYr: Format([fstrlsedt],"yyyymm")

 

[Keven Denen]

Formating builds a string (text) and it then performs an alpha sort.

Use second field for sorting --
    SortMthYr: Format([fstrlsedt],"yyyymm")

--
Build a little, test a little.

I have problem to sort below field in my query.([fstrlsedt]-date field

RelMthYr: Format([fstrlsedt],"mmm-yyyy")

I expect to get Jan-2009,Feb-2009 & so on...but turned out to be
Apr-2009,Aug-2009,Jul-2009....

Thanks- Hide quoted text -

- Show quoted text -

Asking the same question twice in two different threads is fairly bad
form. I and a couple others answered this in the other thread.

Keven Denen

 

[zyus]

Formating builds a string (text) and it then performs an alpha sort.

Use second field for sorting --
SortMthYr: Format([fstrlsedt],"yyyymm")

--
Build a little, test a little.

I have problem to sort below field in my query.([fstrlsedt]-date field

RelMthYr: Format([fstrlsedt],"mmm-yyyy")

I expect to get Jan-2009,Feb-2009 & so on...but turned out to be
Apr-2009,Aug-2009,Jul-2009....

Thanks- Hide quoted text -

- Show quoted text -

Asking the same question twice in two different threads is fairly bad
form. I and a couple others answered this in the other thread.

Keven Denen
.

Hi Keven,

My 1st posting never been displayed after 3 hours of waiting. so i thought
it's not successful. So i attempt to post 2nd question and came out 2 posting
on the same topic.

Appreciate if you have responded to my queries...