How to convert days into years validation

sony8
Tera Contributor

Hi ,

 

I have following requirement.

 There is a field called age on my record producer form . But the age field is coming from other table which is in days . 

i need to convert days into years.

 

field : date of birth = 9087 days( from current date) 

variable : Age = date of birth in years

 

i am not understanding how many years old the student is using date of birth field.

 

please help me how to achieve this ?

1 ACCEPTED SOLUTION

Danish Bhairag2
Tera Sage
Tera Sage

Hi @sony8 ,

 

Just try dividing it by 365.

 

Something like this

9087/365

 

Where do u want it converted?

Record producer form? onChange of some field?

 

Thanks,

Danish

 

View solution in original post

1 REPLY 1

Danish Bhairag2
Tera Sage
Tera Sage

Hi @sony8 ,

 

Just try dividing it by 365.

 

Something like this

9087/365

 

Where do u want it converted?

Record producer form? onChange of some field?

 

Thanks,

Danish