Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
Anyone know how to transform days to years months days? (ex: 400 days >> 1year 1month 5days) where: year=365, month=30.
Tks
This works:
div(400,365) & ' Years ' & div(mod(400,365),30) & ' months ' & mod(mod(400,365),30) & ' days'
Just replace this 400 everywhere with the field name.
This works:
div(400,365) & ' Years ' & div(mod(400,365),30) & ' months ' & mod(mod(400,365),30) & ' days'
Just replace this 400 everywhere with the field name.
I too have found this to work. On occasion, I noticed the days will be off by a day or two. Probably due to some months not adhering to an average of 30.x. I've been looking for a way to accommodate that using this same type of formula...using Mod or fMod.