Forum Discussion

joansinho's avatar
joansinho
Advocate I
7 years ago
Solved

Current Month Comparison

Hi everyone,   I need some help with a calculation. I need to create a new column that shows if an application has been returned the "Current Month." If the application has been returned the curren...
Need Help
  • jthomson's avatar
    jthomson
    7 years ago

    Think your IF statement is using incorrect logic, by the looks of thing it's only going to return yes if your return date is exactly the first of the previous month. Why not try something like:

     

    Returned = var todaysdate = today()

    if ([recentreturn] = blank(), "no", if (month([recentreturn])=month(todaysdate)&&(year([recentreturn])=year(todaysdate),"yes","reset")

     

    i.e. compare the year and the month of your column to the year and the month of today and see if they both match

jthomson's avatar
jthomson
Solution Sage
7 years ago

Think your IF statement is using incorrect logic, by the looks of thing it's only going to return yes if your return date is exactly the first of the previous month. Why not try something like:

 

Returned = var todaysdate = today()

if ([recentreturn] = blank(), "no", if (month([recentreturn])=month(todaysdate)&&(year([recentreturn])=year(todaysdate),"yes","reset")

 

i.e. compare the year and the month of your column to the year and the month of today and see if they both match

  • joansinho's avatar
    joansinho
    Advocate I
    7 years ago

    Hi jthomson!

     

    Thank you for the response!

     

    Your formula worked as expected.