Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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

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

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