Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • I am a newbee, I have a spreadsheet that I need to have the data sorted by closed status and date column based on a particular date. Thanks for any help to where I can start.
I am a newbee, I have a spreadsheet that I need to have the data sorted by closed status and date column based on a particular date. Thanks for any help to where I can start.

Depending on how your date is formatted the Sorter can do the trick. Ideally your date should be in year-month-day format (aka "FME Date") so it's just a number. If you need to convert it, try the DateTimeConverter before the Sorter.

Depending on how your date is formatted the Sorter can do the trick. Ideally your date should be in year-month-day format (aka "FME Date") so it's just a number. If you need to convert it, try the DateTimeConverter before the Sorter.

Thanks seems to work.

But it’s looks like I didn’t expand on it more. But need to sort by date within in a 60 days timeframe and also the aworkorders that are closed(in a different column).

Reply


Community Stats

30,123
Posts
114,333
Replies
37,751
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.