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