Showing all events for tomorrow?

[rjp]

Any idea how i can shoe all records for tomorrow? I don’t see the options to build this query.

If we had the option of today then I could say after today and before 2 days from now?

[rjp]

yes, but cant wor as a filter? when I select the date field it needs to be, before, after or between.

so tomorrow is not before tomorrow, or after tomorrow so I need before two days from now and after today.

[iron49man]

Show me the root of what you’re trying to filter

[rjp]

I have a DB field start data. I want all events with a start date of tomorrow to be shown in a list. But can’t see how to do it?

[iron49man]

This should do the trick. Let me know if this works.

[rjp]

Thanks, that’s the first thing i tried, and nothing

[rjp]

NO LOVE.

[rjp]

ALSO STRANGE WHEN I PRESS ON ITEM THAT SAYS 4 days it shows up as five days on next screen, same data source, same filter? they do this all over my app.

[iron49man]

A temporary workaround may be to set two date picker fields on the page with zero percent opacity. Autoset them to each be tomorrow with filter between the two like such:

Set filter:

[rjp]

Thought about that but hat workarounds

[iron49man]

Does the workaround I suggested work?

[rjp]

No, it doesn’t seem to work.

[rjp]

[vancewong]

I think the issue is that “Tomorrow” refers to 12:00am.

Any date for that matter in Adalo refers to 12:00am.

If we could use Magic Text and formulas in the filters, then it would be possible.