Skip to main content
Question

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.


Forum|alt.badge.img
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.

2 replies

redgeographics
Celebrity
Forum|alt.badge.img+50

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.


Forum|alt.badge.img
  • Author
  • April 3, 2023
redgeographics wrote:

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).


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings