Forum Discussion

heathernicole's avatar
heathernicole
Icon for Continued Contributor rankContinued Contributor
10 years ago
Solved

Calculated Column that only pulls data for Current year

I am trying to create a calculated column that Counts the age of a customer in Days IF the time the customer was created was THIS YEAR.   I've come up with multiple IF statements but nothing has wo...
  • heathernicole's avatar
    heathernicole
    10 years ago

    Figured it out!! :D  Code is included in screenshot. :)

     

heathernicole's avatar
heathernicole
Icon for Continued Contributor rankContinued Contributor
10 years ago

Figured it out!! :D  Code is included in screenshot. :)

 

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

heathernicole Great Job once again!

 

Yes you can't have a conditional statement produce a number if true and text if false.