| Author |
 Topic  |
|
|
perkeo
Junior Member
Germany
124 Posts |
 Posted - 24 Jul 2006 : 20:26:10
|
hi alessio,
unfortunately xmm sorts its view not really on DateInsert -- it only sorts by DAY and nothing else. can you please fix this little item:-)
thanks & kind regards
perkeo |
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
Posted - 25 Jul 2006 : 10:54:06
|
Hi Perkeo,
It depends on how you visualize the Date of Insert in the Grid. If you select for example a "mask" like yyyy-mm-dd you will be able to correctly sort by Date of Insert
Alessio |
 |
|
|
perkeo
Junior Member
Germany
124 Posts |
Posted - 27 Jul 2006 : 20:34:17
|
| actually i use the format dd.dmm.yyyy and it sorts on "dd" only... what can i do? |
|
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
Posted - 28 Jul 2006 : 09:53:41
|
Hi Perkeo,
Please try to use the format yyyy.MM.dd, this should correctly sort by Date Insert.
Alessio |
|
|
|
perkeo
Junior Member
Germany
124 Posts |
Posted - 29 Jul 2006 : 11:14:51
|
oki - it works as you described.. is it possible to realize this for my preferred format dd.mm.yyyy also?? so - it should be possible:-)
perkeo
|
|
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
Posted - 29 Jul 2006 : 17:17:37
|
I am sorry Perkeo, but with this form you will not be able to sort correctly the date of insert.
Alessio |
|
|
|
perkeo
Junior Member
Germany
124 Posts |
Posted - 06 Aug 2006 : 23:55:25
|
| why? |
|
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
Posted - 07 Aug 2006 : 17:59:39
|
Because all data inside the Grid are Alphanumeric, so the Date of Insert in dd/MM/yyyy will be wrongly sorted . For the Grid this is NOT a date, but it's a normal String, this is why will not be sorted correctly.
I hope you understand my bad english 
Alessio |
|
|
|
perkeo
Junior Member
Germany
124 Posts |
Posted - 07 Aug 2006 : 21:51:57
|
| so - let's change the data-structure:-) |
|
|
|
Mawu
Senior Member
Germany
1039 Posts |
Posted - 27 Apr 2007 : 11:06:57
|
Hi Alessio!
Is there any news about this topic, that means to change the character of the date insert field that a sorting of dd-mm-yyyy is also possible? yyyy-mm-dd is very unusual in middle europe.
BTW: most of the data fields dealing with dates or numbers need a kind of "relaunch" because there a lot of bothering problems: 01.01.1900  , no dd-mm-yyyy possible for dvd release year (although you can grabb the whole release date with scripts), no currency for price/value etc. |
|
|
| |
Topic |
|
sorting on DateInsert