Current Age (Date + Calculation) not updating in real time, advice ?

[ThatAlbinoThing]

Morning!! 

I have a database for my animals and I have their ages in days (or /30 for approx months for the older ones) as a status on their cards.

My issue is that the age does not continue counting beyond the date that I set it despite being set to 'Current Date' in the calculation.

So I have 3 fields, 

"Birth" - Date, set to the animals DOB. 

"Date Count" - Date, set to current date and time, dd/m/yy, data validation to 'Today' and dependant on another field for 'Satus' (Which tracks if the animal is Active, Under Observation or Deceased. Date count is set to not show if the animal is deceased. I have tried this with and without this dependency and it doesn't make a difference though I thought I'd mention it just in case). 

"Age" - Calculation, "datediff(#{Birth}, #{Date Count})", this is set as the status. 

This returns the animals age fine, but the date will not progress passed the date I set it to. For example, I set a tester age on the 19/06, for 17/06; it's now 21/06 and is still showing '2 Days'. 

I have ensured both my devices that it's linked to are up to date, and Memento recognises the current date when I go to change the format or set another age calculation. Its just the ones that have already been set will not update unless I completely clear the field, refresh the database, and come back and set it again. 

I'm not very java savvy, but I have tried everything I can from the Memento Wiki and searching the Internet but I've exhausted other options. Can anyone help? 

Thank you in advance 

Beth~

[Bill Crews]

Uh, the age you're calculating is from birth to the data the entry was created. Don't you want age until now? If so, use the expression datediff(#{Birth}, now()).

--
You received this message because you are subscribed to the Google Groups "mementodatabase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mementodataba...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/9ef1eaa5-3196-4a43-b7b7-9d957b970286n%40googlegroups.com.