How do you subtract the year from the current year

[mamdi122003]

I am trying to force the user to enter their age but not less than 17 from the current year.

[brad]

In the data formatter when you select your value choose Date —> Add Years and set value to -17

[mamdi122003]

Hello,

I tried it. I receive this error.

[brad]

You might needed to also use the formatter to convert to date. I’m not at my computer at the moment so can’t provide screenshots.

[brad]

You might also check this post ...

Calculating Age from Date of Birth

Usually we store users dates of birth in our database table, in a DATE field type. You can easily calculate the age of your users, using the App Connect Data Formatter component on your page. We created a dynamic table, displaying the data from our database and one of the columns displays the dates of birth. It’s currently displaying the dates in the default database format, but you can format them as you need (that’s not the topic of this tutorial) : [Screenshot_36] The first thing we need…

[mamdi122003]

I checked it. I think i understood a little bit but I just don’t even want to bother giving them access to the database and put it their birthday is not meeting the requirement of the site.

[psweb]

This is going to need more than just a min of the value, it first needs to know the current date.

1. Add a Data > Date and Time component first
   
   
2. Select your Number Input and add a Dynamic Attribute
   You want the year from the date and time component then the addYears -17, then the get Year so your bindings formatter will look like
   
   All this will do is set the min parameter of the number field to 2003.

The code should look like

<dmx-datetime id="var1"></dmx-datetime>
<input id="text1" name="text1" type="number" class="form-control" dmx-bind:min="var1.datetime.addYears(-17).getYear(var1.datetime)" required="">

[mamdi122003]

Thank you for your help.

It is working perfectly.