Calculate the Age of a person by now - BOD

Help Activities
, ,
1

How to calculate age using date of birth using excel in uipath?

CInt(New DateTime((Now - Covert.ToDateTime(row.item(“DOB”))).Ticks)).toString(“yyyy”))

Tried this but no result

2

grafik

3

How to add column name to this condition?

4

now.Year - CDate(row(“DOB”).toString).Year

5

Nothing changed

6

please share with us the details from your implementation
how is it used in the imp
what are you getting / facing

thanks

7

I need to calculate the age from date of birth given in excel sheet…if the age is greater that 18 i should print in new tab else another tab, fetched the excel and set an assign condition inside for each and then used if else to set Age<18 but nothing happens

8

grafik
grafik736×163 28.1 KB

9

Screenshot 2021-06-18 173614
Screenshot 2021-06-18 1736141140×569 15.3 KB

all the tab is same data

10

No Error but excel tab contains same data for both tabs

11

please have a look on the screenshot from above where we do use <=

12

same result

13

a too short feedback.

please share the updated imp part
have you debugged (e.g. stepwise the relevant parts and crosschecked the variable values during the flow?

in case you want to toute a person with the age of 18 to major then change
If now.Year - CDate(row("DOB").toString).Year >= 18
Then: major
Else: minor

14

I checked that too, but no result…

15

Your write range is using the same variable. What’s that variable?

16

its data table variable name

17

Corrected Version below

18

@ayana_augustine - Let me ask you this first…

  1. what is your DOB column format?
  2. What is your system local settings time format? Because Cdate won’t covert all the date formats , it will work as per your local settings. see below…

image

19

yes its different

20

Please read my post my again…i asked for the format