Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a box with list of values based on a column in my database.
I want to exclude certain values in the list box. e.g.
List box with data
2015-01-01
2015-01-02
2015-01-03
etc.
i want to exclude all data with date befor 2015-01-03. How can i do that?
Instead of adding the Field you can select expression from the drop down when you create your list box.
=If( aDate >= MakeDate(2015,1,3) , aDate )
Then you will filter out older dates...
Yes if you just use a formula when you load the field then it will limit the date of the fields being added.
Field
Field
if(DateField <= Date(2015-01-03), DateField) as DateField
Field