date calculation | ww.wp.xz.cn

Resolved ajaysingh121
(@ajaysingh121)

3 years, 2 months ago

how we can evaluate the equation, I want to input in the calendar only the year and in the result show today’s date -the user enters the date in the year plus 1-year show

Korean age = (current year – year of birth) + 1

Viewing 3 replies - 1 through 3 (of 3 total)

Plugin Author codepeople
(@codepeople)

3 years, 2 months ago
Hello @ajaysingh121

Assuming you have the fieldname1 date field for entering birthdate, the equation would be:
```
DATEDIFF(NOW(), fieldname1, 'dd-mm-yyyy', 'y')['years']+1
```
Learn more about the Dat/Times operations by reading the following section in the plugin documentation:

https://cff.dwbooster.com/documentation#datetime-module

Best regards.
Thread Starter ajaysingh121
(@ajaysingh121)

3 years, 2 months ago

in the calendar, I want to only the year required, not month and day.
Plugin Author codepeople
(@codepeople)

3 years, 2 months ago
Hello @ajaysingh121

In this case, you should not use a calendar field. You can use a DropDown field with the years list or a number field to enter the year in which the user was born, and the equation would be:
```
ABS(YEAR(TODAY()) - fieldname1)+1
```
Best regards.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘date calculation’ is closed to new replies.

3 replies
2 participants
Last reply from: codepeople
Last activity: 3 years, 2 months ago
Status: resolved