Formula for Status

[paula]

Hello,

What should I put as app formula to get these results,

if [DateHired] is 'not more than a month ago', display "Newly Hired" as [Status], otherwise "Old"

Thank you!

[Suvrutt_Gurjar]

IF([Date Hired]>= TODAY()-30, "Newly Hired", "Old")

[Hussein_Osseily · Accepted solution]

---

@paula wrote:

if [DateHired] is 'not more than a month ago', display "Newly Hired" as [Status], otherwise "Old"

---

I believe that there are several approaches but you can try this:

If its based on the month and not the number of days then you can try this: 

IF(MONTH([DATE HIRED])=MONTH(TODAY())="Newly Hired","Old")

If its based on the number of days (30 days): 

IF(today() - [date hired] <= 30 , "Newly Hired" , "Old")

Another Approach: 

IF(TOTALHOURS(TODAY() - [DATE HIRED])/24 <= 30 , "Newly Hired" , "Old")

Unless you have a specific criteria in calculating the time cycle for determening the days 

Feel free to feedback how you want to tweek it if it's not giving you what you want

[paula]

Thank you so much!