HI, I have made a custom field in Outlook in my tasks using a formula. The formula is using a iif to pick dates or text. So the field has dates or the word "None". I would like it converted to a datefield and then sort by it.
I have tried Datevalue(....) and it seems to work. But when I try to sort it Outlook says "Cannot Sort By This Field."
I really want to use this field to choose which Task to do next.