- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-21-2023 07:18 AM
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 ?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-21-2023 07:25 AM - edited 11-21-2023 07:26 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-21-2023 07:25 AM - edited 11-21-2023 07:26 AM
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