Hi,
is there an way to give the autofilterobject an other sorting style?
Example:
in the Col there are Text values in the style "01.02.16", "01.03.16", "05.02.16"
if it is sorted it has the following style (is ok, because TEXT)
"01.02.16"
"01.03.16"
"05.02.16"

but i need that the filter looks like

"01.02.16"
"05.02.16"
"01.03.16"

if have no choice that i format the values in col
do you have an idea?
regards Thomas

If you store dates use the native DateTime type, they should be sorted properly (in the chronological order) by AFM.

Most likely, you store your dates as strings. If it is not the case, send us a sample that demonstrates the issue.

Hello Igor,
well i know this with the date format, but the data are comming as Text,
an they should stay as text. So i need an other fox for this problem.
The example are the 3 Text Items that i send you.
This is the input in 1 col an i want to format the values BEFORE they are
filtered from the AFM.
regard thomas

H-m-m, if they come as text, they won't be sorted properly in the grid too. If you do not do so, you have problems like these:

http://10tec.com/forum/p...sort-a-column-with-dates 

If your dates are stored as real DateTime values, you can always apply a format string to them to display them on the screen in the desired format.

Hello Igor, your thinking like sherlock 🙂,
this not right, because the sorting is coming from the Database.
The col needs to be Text because the grid calculates with formulas.
I know if it was stored as date in the col there will be no problems.
Thats why i send you this, maybe it will be a nice feature that the
AFG hat his own formating.
regards Thomas

Is it a problem to "calculate" the column's cell values as dates (in fact, they are dates)? Or place these values into the grid as text in one column and then convert them into dates in another column the user will see?

If you can reveal more details about your app (some source code, database structure, etc.), perhaps, we can suggest another way to solve your problem.

Hi Igor, it is not possible to let you more as this facts.
The database is more then 5GB large. it runs on an sql server and the
col with the silly format is the base for other calculating.
So it was my idea that the AFM has this useful property (Colformat)
i would have no trouble at all because the AFG could Format everything
in a other way as the original col.
If i change the code for the formating in the col, the base col pulls
much tests and programming for other interfaces that using this coll.
my customer is not willing to pay that.
regards Thomas