Skip to main content
Topics#Data ManagementKris Webster의 질문
Kris Webster 님이 #Data Management에 질문했습니다
2019년 6월 6일 오후 1:16

Rolling Years in IF Statement

I am trying to use a formula field to update the field based on the date of another field. If the date of the field live_date__c falls within a specific peramiter then the formula will update this formula field with some text. 

 

I have it working for the year of 2019, however I was hoping to have this formula field look at any and all years and update this new field. 

 

SO for example as it is now if the live-date__c is 3/6/2019 then the new field will auto populate with Q1. What I want to add is if live_date__c is 3/6/2018 I would like the new field to auto populate with Q1 as well. Right now I only have functionality for 2019. 

 

Here is the formula... it is just a simple IF statement.. 

 

F(Live_Date__c <= DATE (2019,3,30), "Q1", 

 

IF(Live_Date__c <= DATE (2019,6,30), "Q2", 

 

IF(Live_Date__c <= DATE (2019,9,30), "Q3", 

 

IF(Live_Date__c <= DATE (2019,12,30), "Q4","Please Set Live Date"))))

 

Thanks in advance! 
답변 3개
  1. Kris Webster
    2019년 6월 6일 오후 2:15
    Good call!! Thanks my man ! @scott Mcfarlane
답변을 작성하세요...
0/9000