My first post: Problems with sorting dates…

[Michael7419]

Hi Forum-Members -)

I have a task-DB, in which I want to sort the tasks after the Deadlines automatically. So I have the tasks sorted after the "priority". There is only one problem: If the field Deadline is empty, these tasks are sorted to the beginning! (Maximum of priority!) But if I finished a task, i clear the deadline... that's only one reason for not all of the tasks having deadlines. By the way, it's a pain to write a script for searching and sorting combined.

Any help is more than appreciated!

Hopefully my English is not tooo bad to understand :-)

Michael7419

Edited September 7, 2010 by Guest

[comment]

It would help knowing what do you actually want to happen: show the tasks with no deadline at the end, or not show them at all.

[Michael7419]

It would help knowing what do you actually want to happen: show the tasks with no deadline at the end, or not show them at all.

I like to not show tasks with no deadline at all, but sorted after date...

Thanks for your thoughts!

Michael

[comment]

:idunno:

If you don't want to show tasks without a deadline, then what does it matter how they are sorted? You can only sort records in the found set.

[Michael7419]

Thanks for participating. I have a running script now -)