157 Posts
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
118 Posts
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.
157 Posts
1 year ago
0
Level 2
Yes, it works fine, thanks !