Export sorting


#1

Hi,

Export sorting works fine on all fields except when it involves a date :frowning:

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


#2

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


#3

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 :frowning:


#4

Excellent :slight_smile: %_file_create_datetime_raw% works just fine.

Steve