Hi,
I want to add a filter form to a screen to make it possible to filter the results. in the grid. since the added_on is generated, i can't use it in the filter form. I added a lookup field to show the generated added_on field with the following expression:
(select cast(convert(varchar(11), added_on, 105) as nvarchar))
The expression field has the domain ‘name’ which is a NVARCHAR(200).
In subjects i've set the filter condition to ‘Between', but it only shows ‘Equal to’ in the grid. I can change it to ‘Contains’ and this does change and shows in the GUI.
I would like to know what i can do.
Kind regards,
Linde
