1 Reply Latest reply on Jun 16, 2014 10:02 PM by davidanders

    Creating a life clock

    NeoTekCorp

      Title

      Creating a life clock

      Post

           Working on interesting project. Trying to calculate and display a persons age in various ways.

           Years

           Months

           Days

           Hours

           Minutes

           Seconds

           I've been able to pretty easily set up the calculations for the Years thru Days using GET function between BirthDate and CurrentDate. Trying to figure out the best way to fourth break things down for total Hours, Minutes & Seconds.

           Off the top I'm thinking about the obvious addition of a BirthTime TIME field. Figured I could then use that data and add it to the total Days, multiplied accordingly (x24 for hours) then (hours x60 for minutes) then (minutes x60 for seconds) each of which would then have the TIME STAMP for the birth time added and calculated accordingly.

           The end result would allow the user to quickly see an age in a variety of ways, including total hours, minutes, seconds.A

           Any thoughts on the best way to set this up? Thanks in advance for the input and wisdom. Much appreciated.