Skip to main content
Topics#Data ManagementOlivia Forde의 질문
Olivia Forde (Lifes2good) 님이 #Data Management에 질문했습니다
2015년 10월 21일 오전 9:00

How can I check if a date is between two dates

In a formula I want to check if a date is betweeen two other dates (fields) how do I do this.

 

I treid this (if it is I want to add 1)

 

if (

 

AND( 25/12/2015  >= Leave_Start_Date__c ,25/12/2015 <= Leave_Finish_Date__c ), 1,0)
답변 9개
  1. Atul Gupta (CloudVandana Solutions)
    2015년 10월 21일 오전 9:15
    if you just want to check if the date falls between two dates, you can use this

     

     

    IF(
    AND(
    Leave_Start_Date__c <= DATE(2015,12,25),
    DATE(2015,12,25) <= Leave_Finish_Date__c
    ), true, false
    )

     

    true means date does falls between leave start adn leave finish dates.

     

    Let me know if you need any further help on this.

     

    Please mark a Best Answer to close this thread.
답변을 작성하세요...
0/9000