List Manager Forum

Event List: View without dates in the past

Usuario pfnuesu 2017-07-30 22:52:08

Hi there

I've created an event list with various types of events in the coming few months.

Creating a view of this list per event type was fairly easy but ... I have to find out yet how to display only entries in the future.

I imagined something along the lines of
-> more than -> today()-1 (or even "date (today) -1"
as of is of type "date"

Unfortunately, that didn't work - so: how can I accomplish my task?

Thanks and regards,
Markus

Moonsoft support 2017-07-31 08:53:38

Hi,

You can set in field->data filter in your view the combo to 'More than' and text field to

NOW()

Similar expression are also valid to compare different date intervals like

NOW() + INTERVAL 7 DAY

(From next week)

NOW() - INTERVAL 1 MONTH

(Past month)

Regards,

Usuario pfnuesu 2017-07-31 09:10:53

Thanks - works like a charm :)

...
Support/development 10 hours

Get a bigger amount of hours for more complex tasks and get a 10% discount

Buy now!
...
CalcBuilder

Create dynamic calculators

Buy now!