Forum Discussion

domtrump's avatar
domtrump
Icon for Helper II rankHelper II
3 years ago
Solved

Calculated Column for one year from today

I thought this would be really simple, but it is proving to be a serious nusance. All I want to do is determine if a date in one column of my table is within the last 12 months. I need this in a calc...
  • vicky_'s avatar
    vicky_
    3 years ago

    Try:

    IF(DATEDIFF(TODAY(),[Specific Date], DAY) <= 364,"ACTIVE","NOT ACTIVE")
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi domtrump 

    Try to add a column with this:
    Status1=
    IF(
       [Date]>=EDATE(TODAY(), -12),
       "Yes",
       "No"
    )
     
    or 
    Status2=
    IF(
    [Date]>=DATE( YEAR(TODAY())-1, MONTH(TODAY()), DAY(TODAY())),
    "Yes",
    "No"
    )
     
    DATEADD is Time Intelligence function, which always replies on dedicated Date Tabke.
vicky_'s avatar
vicky_
Icon for Super User rankSuper User
3 years ago

Try:

IF(DATEDIFF(TODAY(),[Specific Date], DAY) <= 364,"ACTIVE","NOT ACTIVE")