HTML5 Data Bindings Support Product Page


Filter records by current date

Asked 01 Sep 2014 21:21:39
has this question
01 Sep 2014 21:21:39 Brad Lawryk posted:
I know I saw this somewhere but how do you filter a recordset to only show records from current date?


Replied 01 Sep 2014 21:54:59
01 Sep 2014 21:54:59 Teodor Kuduschiev replied:
Hi Brad,
In the filters section of database query builder you can use "now" - this returns today's date.
Replied 01 Sep 2014 22:00:11
01 Sep 2014 22:00:11 Brad Lawryk replied:
Ah, that's it ..... I tried date() and now() but neither worked.

Replied 04 Jan 2015 11:34:02
04 Jan 2015 11:34:02 Mim UK replied:
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

Replied 31 Jan 2015 21:24:10
31 Jan 2015 21:24:10 Brad Lawryk replied:
Hi Mim,

Filter your date field by 'entered value' and for the value put 'now+1day' without the quotes.
Replied 01 Feb 2015 08:19:04
01 Feb 2015 08:19:04 Mim UK replied:
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.
Replied 01 Feb 2015 15:34:12
01 Feb 2015 15:34:12 Brad Lawryk replied:
For tomorrow I use '=' and 'now+1Day'
For the last week I use '>=' and 'now-7days'

Filtered on your date field of course.
Replied 01 Feb 2015 17:49:19
01 Feb 2015 17:49:19 Mim UK replied:
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.
Replied 01 Feb 2015 18:47:05
01 Feb 2015 18:47:05 Brad Lawryk replied:
Might be a MS SQL thing then? I use mySQL ....
Replied 15 Nov 2016 09:37:00
15 Nov 2016 09:37:00 Dik Hendriks replied:
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?

Reply to this topic