nuBuilder Forum

I have a launch form that filters a table below with the date which is a date field. The table below contains a datetime-local because I need the time. When I filter with the current date the liste below is empty : I have to create a second field containing the date only. Is there another way to perform this operation ?

How is the table filtered?

It's filter by acc_date which is a date and not a datetime

What date format has acc_date? You might have to convert it to the format yyyy-mm-dd when passing it in nuFilterRun()

acc_date is in 'dd/mm/yyyy format'. I will try by changing the format.Format of the DateTime in tache_iframe is 'dd/mm/yyyy hh:nn' with is the same as acc_date. Do you think that the system doesn't take those formats into account but works with the default format for the search ? I will try. Thx

Try with a static date value like nuFilterRun('tache_iframe','2022-04-03') to see if the iFrame is refreshed. Then you know if the date needs to be in that format.

If I change nuFilterRun('tache_iframe', '#acc_date#') by nuFilterRun('tache_iframe','2022-04-13') in order to filter on the 13th of april, it doesn't work. Could you please explain how the filterRun works on dates ?

nuFilterRun() adds a WHERE clause in your SQL. When you inspect the generated SQL (Option Menu, Form Info) you will see an sql like
If you convert your date format from dd/mm/yyyy to yyyy-mm-dd, the filter should just work fine.

Thx Kev1n, it works with your proposal.