Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
Little yet annoying problem, I have a listbox with a set of dates, however, I want it to show dates for only the period from 04/11/2013 till 27/11/2013. I tried putting it into sort by expression, but it still returns dates for December too.
Thank you!
Anna
Hi Anna,
if you right-click your listbox, in the context-menu you have a subpoint "Advanced search" where you can enter complex search_expressions including IF constructs.
Try entering something along the lines of this:
>>> = [date] >= '04/11/2013' AND [date] <= '27/11/2013' <<<
HTH
Best regards,
DataNibbler
Thank you, but this only provides the search, whereas I'm looking at the listbox displaying only those dates. With expression you have supplied, it searches for the required dates, however, irrelevant dates are still displayed.
Anna
In List Box, try buil an expression,
if ( [date] >= '04/11/2013' AND [date] <= '27/11/2013' , [date], null())
Bruno
See the sample
In the sample i have just used ad ID in List box but you can see the logic of filltering the value.