Use "Joins where"on data join element with value from form (date element)

[confis]

Hi ,
I have date element on my form
I like to select date from it and base on this to show on my drop down element (datajoin element to date filed)
only the label that have the same date

the problem i have is that the
"Joins where and/or order by statement (SQL)" is SQL
and the date picker is Java Script

any idea how to get the value from the data picker on the form and use the SQL Joins where to filter out the not relevant values ?


I hope i clear in the question

Thank you
Yaniv

 

[cheesegrits]

You should be able to use a placeholder for your date element, and use DATE_FORMAT to just compare the date part ...

WHERE DATE_FORMAT({thistable}.your_date, '%Y-%m-%d') = DATE_FORMAT('{form_table___your_date}', '%Y-%m-%d')

... and enable "AJAX Update" for the WHERE.

Replace the first your_date with the date field name in the joined table, and form_table___your_date with the full element name for the date element on your form.

-- hugh

 

[confis]

Thank you very much , this is working very good