Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Ive got a variable containing a date, vLastDate.
I then have in my database a couple of lines looking similar to this;
Place1, 2010-01-01
Place1, 2010-02-10
Place2, 2010-02-10
Place3, 2010-02-10
Place2, 2010-03-04
Place4, 2010-03-04
...
What I want is that when I load the App a listbox should only show the places with the same date as vLastDate.
Its no problem if I select a date manually, but cant get it to work with a expression in the listbox.
Shouldnt be too hard if you know how
Thanks in advance!
try something like:
Place,Date
Place1, 2010-01-01
Place1, 2010-02-10
Place2, 2010-02-10
Place3, 2010-02-10
Place2, 2010-03-04
Place4, 2010-03-04
take a list Box:
In that write an Expression:
=if(Date=vLastDate,Place)
try something like:
Place,Date
Place1, 2010-01-01
Place1, 2010-02-10
Place2, 2010-02-10
Place3, 2010-02-10
Place2, 2010-03-04
Place4, 2010-03-04
take a list Box:
In that write an Expression:
=if(Date=vLastDate,Place)