eusty
January 24, 2007, 7:18pm
1
Hi,
Export sorting works fine on all fields except when it involves a date
I've tried sorting by %_file_create_date% and %_file_create_date_raw% but it only sorts by the day i.e. DD/MM/YYY sorts by DD then MM then YYYY which isn't of much use!!
Is it possible to put the dates in ISO format (YYYY/MM/DD)?
Thanks
Steve
Hmm, ... thinking ...
%_file_mod_datetime_raw% should work.
It returns a sortable number.
|26.03.2005 15:26:37|1111847197|
|22.07.2006 18:10:55|1153584655|
|23.01.2007 00:29:16|1169508556|
|23.01.2007 00:29:20|1169508560|
|24.01.2007 22:17:56|1169673476|
DD.20070124.2252
eusty
January 24, 2007, 8:34pm
3
DetlevD:
Hmm, ... thinking ...
Yup %_file_mod_datetime% or %_file_create_datetime% doesn't sort correctly, I'm not sure how it's sorted as there is no pattern to it I can see
eusty
February 6, 2007, 10:31pm
4
DetlevD:
Hmm, ... thinking ...
%_file_mod_datetime_raw% should work.
It returns a sortable number.
|26.03.2005 15:26:37|1111847197|
|22.07.2006 18:10:55|1153584655|
|23.01.2007 00:29:16|1169508556|
|23.01.2007 00:29:20|1169508560|
|24.01.2007 22:17:56|1169673476|
DD.20070124.2252
Excellent %_file_create_datetime_raw% works just fine.
Steve