I know I saw this somewhere but how do you filter a recordset to only show records from current date?

Hi Brad,
In the filters section of database query builder you can use "now" - this returns today's date.

Ah, that's it ..... I tried date() and now() but neither worked.

Thanks!

Sorry to bring this up on an old thread. But is there a way to filter on now +1? I need to return tomorrows data

Cheers

Hi Mim,

Filter your date field by 'entered value' and for the value put 'now+1day' without the quotes.

Hi Brad,
That doesn't work I am afraid, thanks for the response though
It returns an invalid datetime error

now works but I don't see any way to easily filter by tomorrow or this week etc.

For tomorrow I use '=' and 'now+1Day'
For the last week I use '>=' and 'now-7days'

Filtered on your date field of course.

Bizarre,
That doesn't work for me.
I'm working with an MS SQL datasource and the field is a datetime value.

Both of the examples above return 'invalid time format'.

'now' works fine though.

Might be a MS SQL thing then? I use mySQL ....

I am using SQL-server and want to filter a table, using a date-field, returning all records greater than the current date + 1 day.
Someone solved this?