Date Sort

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have changed the date format on access to dd/mm/yyyy for mail merge to
word. However, I am now unable to sort ascend the full date; the sort ascend
is only picking up the dd.
Has anyone an idea of how to overcome this problem?
Thanks,
 
If your underlying table definition for that field is a Date/Time datatype,
the "format" you use only covers how it is displayed, not how it is stored.

I believe that sorting happens against the stored values.

How are you storing the "dates"?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
And if the backing data is a string (NOT a date_time), then you will get all
the 01/xx/yyyy, then all the 02/xx/yyyy, since your data is not seen as
date, but as string, so, sorted as in a dictionary, all words starting with
the first letter coming before any word starting with a"b", and so on.


Vanderghast, Access MVP
 
Hi,
I have changed the date format on access to dd/mm/yyyy for mail merge to
word. However, I am now unable to sort ascend the full date; the sort ascend
is only picking up the dd.
Has anyone an idea of how to overcome this problem?
Thanks,
Click to expand...

Include both the date field and the formatted string. Sort on the date field,
and export the formatted one.

John W. Vinson [MVP]
 
Back
Top