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.
+25
- Influencer
- 3345 replies
-
3 April 2023
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.