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.
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.
+59- Celebrity
- 3699 replies
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).