I have created a new screen/form for UD105 table that has a couple fields on it. One field is a date. When I enter this date, I want the next field to automatically display the age of the item based on the date that was entered. How do I do this?

What is the next field? Is this in Kinetic? You can create an event on the dataview change to make this happen.

Yes, this is kinetic. I’m doing this in my test area which is running 2024.1.5. field one is Mfg. Date field 2 is Age. I want the system to calculate the date automatically, so the user’s do not have to calculate it manually. I don’t understand your event on the dataview. How is this done?

When you create a new event, you can select the trigger (or no trigger). Ken’s suggestion is to trigger on the view change: [image] @knash I have had trouble getting this to consistently work - do you choose View Changing or View Changed? or something else? or is it just dependent on the screen …

Thanks everyone, I will play with the events to see what I can do. I appreciate all the help.

Calculating age based on an entered date

Kinetic ERP

knash (Ken Nash) June 10, 2024, 8:19pm 5

I followed this post, and it helped me with what i was trying to do.

Adding a calculated field to a kinetic dataview? - Kinetic ERP - Epicor User Help Forum (epiusers.help)

Topic		Replies	Views
Adding a calculated field to a kinetic dataview? Kinetic ERP	36	10837	July 25, 2023
Application Studio - Populate field with BAQ Kinetic ERP	2	346	February 19, 2025
App Studio - copy data from one field to another Kinetic ERP	4	1600	October 13, 2023
Kinetic Dashboard with date search Kinetic ERP	5	81	June 18, 2026
Syntax examples for row-update Expression, especially for a date field Kinetic ERP epicor , customization , kinetic	6	3393	November 3, 2025

Calculating age based on an entered date

Related topics