Forms Builder - Difference between 2 date fields

Hosam Salem

Dear All,

I would to auto-calculate the difference in days between 2 date fields in my form. I thought of using a data-source as follows:

select DATEDIFF(day,DATE('${param_start_date}','mm/dd/year'),DATE('${param_end_date}','mm/dd/year')) from dm_docbase_config

But the issue is if any of the 2 parameter dates is null, as in this case, the query will fail with an un-recognized format.

Any suggestions?

Haroon_A

If you must require the user to input a value for your both fields, you can make them as 'required' in the "Rules" tab of your dates. Else, you could develop your own adaptor, and do the validation.