Chronological Dates

[nancybrown]

Hi Guys,

I have a report the has date formats of Jan 05, Feb 05, etc., Can someone tell me how to put these months in chronological order.

Another issue: Is it possible to take data on a subform datasheet view and format it as a string, e.g.:

Currently Would like: Monday, Tuesday, Wednesday
Monday
Tuesday
Wednesday

Kindest Regards,
Nancy

 

[Norie]

Nancy

Are these dates actually in a date field or a text field?

 

[nancybrown]

Hi,

They're currently in a date field. I modified the format in the query to display as Jan, Feb, etc. Unfortunately I don't want them to sort ascending or descending, but Chronologically.

 

[Norie]

nancy

The format of a field shouldn't affect how it's sorted.

How did you actually do the formatting?

 

[nancybrown]

Hi,


This is the code I used in the query field:

Month: Format([StartDate],"mmm yy")

 

[Norie]

Well by using Format you've changed the date into text, therefore it will be sorted alpabetically.

Where are you actually using the query?

Is it for a report?

 

[nancybrown]

Yes in a yearly financial report that is grouped by month.

 

[Norie]

Well instead of using the Format function, format the date using the Format property.

Just select the date field, goto the Format tab and enter mmm yy.

 

[nancybrown]

Wow, it worked! That was way too easy.

Thanks so much.
Nancy