This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi all,Looking for input, I have data in which I look for the maximum
SCORE of an item, but there could be a scenario where multiple items
have the same max score,Now I don't need to know which Item has the same
score as the others, just that there i...
If anyone gets to this, here's something I found, you NEED to account
for leap years by dividing by 365.25 whe nyou do this, if you don't,
you'll get a year jump a few days before the date (especially on older
people)also, I had to create a Virtual c...
So what if I wanted to know the Age at a specific dateIn my use case it
would be : Age 1st of January of this yearI tried this
:FLOOR(HOUR(Date(01/01/YEAR(TODAY()))-[DOB])/365/24)But results were not
what I expected !
