if(ri!vfm_lastupdate<today()+730,"new",if(or((ri!vfm_lastupdate > today()+731),(ri!vfm_lastupdate>=today()+1440)), "refurbished",if(ri!vfm_lastupdate>today()+1828,"Testing Required","Null")))
here i need to check if the given date is less than 2 years compared to present date then show new, else between 2-5 display refurbished else more than 5 years display testing required
Discussion posts and replies are publicly visible
OK. And what is the result you see? The "or" in the second line looks suspicious.
in the above condition am adding number of days but instead i want to give no of years and check directly. in the or condition am checking between 2-5 years
One option: edate(today(), 24) will add 24 months.
What do you mean with "check directly"
given/entered date is less that 2 years compared to present date
Like this?
ri!vfm_lastupdate<edate(today(), 24)
Try to follow Stewarts advice.
And, writing "it's not working as per required " does no help me to understand what is going on!
Repeating my first post, the "or()" in the second line looks suspicious!