{{tag>Function Function_List Date_And_Time}}
====== DAY_DIFFERENCE ======

===== Description ===== 
Calculates the day difference between the two dates as an integer constant
===== Syntax =====

''DAY_DIFFERENCE (date1, date2)''

Can be used in the condition of a [[:ref:a_f:a:find|FIND]] action.

===== Parameters ===== 
Two attributes of the Date type or date constants or calculations producing date
===== Returns =====

**Number**: the number of days between the two dates, always positive (the order of the dates does not matter)

===== Example ===== 
<code aim>IF DAY_DIFFERENCE (Account.OpeningDate, Account.ClosingDate) = 3 THEN ... </code>

===== Related =====

[[ref:a_f:f:af:day_difference2|DAY_DIFFERENCE2]], [[ref:a_f:f:af:date_add|DATE_ADD]], [[ref:a_f:f:af:week_difference|WEEK_DIFFERENCE]], [[ref:a_f:f:af:month_difference|MONTH_DIFFERENCE]]