Sort by Date

[tim]

I need to sort some records by year, month, day that I imported into a table
from a text file. The date field is in the following format: yyyymmdd

Any help is appreciated

Tim

 

[RBear3]

I believe you would just set it to sort by that field ascending or
descending. What is the problem you are having? Is it not sorting the way
you think it should?

 

[Guest]

If the field is in that format yyyymmdd it will sort it properly

Select * From TableName Order By Val([DateFieldName])

So when it converted into numbers it will be in the right order, probably
also if you left it as string


20060101
20060123
20070224
20070323

 

[tim]

It didn't look like it was sorting right by sorting the field in ascending
order the first time.

Thank you,
Tim

 

[tim]

Thank you, that worked.

Tim

If the field is in that format yyyymmdd it will sort it properly

Select * From TableName Order By Val([DateFieldName])

So when it converted into numbers it will be in the right order, probably
also if you left it as string


20060101
20060123
20070224
20070323
--
Good Luck
BS"D

I need to sort some records by year, month, day that I imported into a table
from a text file. The date field is in the following format: yyyymmdd

Any help is appreciated

Tim