Skip to main content
Solved

Sorting 'date' using sorter with option Alpha/Num does not work Sorting 'dates': Regular sorter on dates( e.g 26/05/2023....) as alpha/num options do not work.Could there be another way to do this date sorting?

  • September 8, 2023
  • 2 replies
  • 245 views

angwan
Contributor
Forum|alt.badge.img+7

image

Best answer by nielsgerrits

You need to convert the date to fme date first. This can be done using the DateTimeConverter.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

nielsgerrits
VIP
Forum|alt.badge.img+60
  • 2938 replies
  • Best Answer
  • September 8, 2023

You need to convert the date to fme date first. This can be done using the DateTimeConverter.


angwan
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • 14 replies
  • September 8, 2023

You need to convert the date to fme date first. This can be done using the DateTimeConverter.

Thanks @nielsgerrits, that works with fme date format(e.g. 20230526). Limited though, if one would like to have a different date format that requires sorting.Cheers.