I am having difficulties with creating a listbox to select tickets from our management system.We look at our tickets in a monthly perspective and like to follow tickets created in a specific month or tickets closed in the same month. Users inputs StartDate and EndDate. A ticket always has a creation date but not always a closed date (ie. field is null() ).I have made a listbox with the following expression:
=if ( not isnull (TicketClosed),
if ( (TicketCreated >= StartDate and TicketCreated <= EndDate) or
(TicketClosed >= StartDate and TicketClosed <= EndDate), 'Yes', 'No'),
if (TicketCreated >= StartDate and TicketCreated <= EndDate, 'Yes', 'No'))
Listbox title is obvoiusly "Tickets created or closed in period".
Listbox shows the proper Yes and No, but I end up with all tickets but the ones that have no TicketClosed date, ie. TicketClosed is null().
Anyone with an opinion on this or event better a sugestion for doing it otherwise?
