HTML5 Data Bindings Support Product Page
Filter records by current date
Asked 01 Sep 2014 21:21:39
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:
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:
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:
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