154 Posts
Hableur
1 year ago
2
Topic

Hello,

I don't arrive to make match date working.

I have a field date varchar date in it format yyyy-mm-dd.

I want to test it with curdate () (selecting only when date is >= curdate()  or date is null).

So I select Future (> or =) or Null

I don't uderstand where setting the comparaison date (in fact curdate() or now).

In seblod doc : Future only: This will only show results whose dates come after the input date.


But where is the input date ?

Thanks

Get a VIP membership
1 year ago
1
Level 1

Hi,

Is your field visible or hidden in your search ? If hidden, you can set a live value of type 'SQL Query' and in the live config, use the 'SELECT CURDATE()' query.

154 Posts
Hableur
1 year ago
0
Level 2

Yes, it works fine, thanks !

Get a Book for SEBLOD