Is it possible to use the calculate field with datepickers in a different dateformat then the actual form output? I’m working on a membership form where users input their date of birth with a datepicker. The output for the form/email should be d-m-Y.
Thru a hidden calculate field I’d like to do a conditional age check {current_date:Y}-{datepickerID}. If the result is less then 18 additional fields need to be filled out.
I can change the dateformat in the datepicker element to ‘Y’ to get the desired result for the calculation but then I end up with only the year in the actual form output. If I leave the dateformat at d m Y I get no result in the calculation field. Any suggestion on how to tackle this problem is very welcome.